CHOUDHARI

-- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-- Author       : Sameer S Choudhari
-- Description  : Describes all objects in the database.
-- Call Syntax  : @dba_objects.sql
-- Last Modified: 20/03/2015
-- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
SET LINES 220 PAGES 49999
COLUMN owner FORMAT a30
COLUMN object_name FORMAT a30
SELECT owner,
       object_name,
       object_type,
       created,
       status
FROM dba_objects
ORDER BY
  owner,
  object_type,
  object_name;