REM #######################################################################
REM * @c:\oracle\sql\db_dic01.sql                         
REM *                                                       
REM * Owner: R.Kupcunas                                     
REM * Date:  03-MAY-95                                      
REM *                                       
REM # Display information about all of your own objects            
REM #######################################################################

break on "OBJECT";
set pagesize 60;
set linesize 80;

spool db_dic01.rslt;

set feedback on;

select substr(object_name,1,25)   "OBJECT",
    substr(object_id, 1, 5)       "ID", 
    substr(object_type, 1, 10)    "TYPE", 
    created                       "CREATED", 
    last_ddl_time                 "UPDATED",
    status                        "STATUS"
from user_objects
order by 1 asc;

spool off;

