Show Installed DB components 

-- 
-- 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

Subscribe to: Posts (Atom)