--
-- Title : showinstalled.sql
-- Description : To show installed database components.
--
-- Usage/Notes :
--
-- Copyright : ABCdba.com 2010
--
COL comp_name FOR a44 HEA 'Component'
COL version FOR a17 HEA 'Version'
COL status FOR a17 HEA 'Status'
SELECT comp_name, version, status FROM dba_registry
/
No comments:
Post a Comment
Note: only a member of this blog may post a comment.