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