-- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-- AUTHOR           : Sameer Choudhari
-- DESCRIPTION      : Displays information about the components loaded into the database.
-- USAGE            : @database_components.sql
-- LAST MODIFIED    : 17/03/2015
-- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
SET lines 220 pages 49999
COLUMN comp_name format a60
SELECT comp_id,
  comp_name,
  VERSION,
  SCHEMA,
  status
FROM dba_registry
ORDER BY comp_name;