— obj_lst.sql
— mdw 02/02/00
— very simple tables listing
set pause on pages 24 pause ‘Any Key>’
col owner form a10 wrap
col object_name form a20 word wrap
spool obj_lst.lst
select owner
,object_name
,substr(object_type,1,10)  obj_type
,to_char(created,’DD-MON-YY’) cre_date
,to_char(last_ddl_time,’DD-MON-YY HH24:MI:SS’) last_ddl
from  dba_objects
where object_name like upper(nvl(‘&obj_name’,’WHOOPS’)||’%’)
and object_type like upper(nvl(‘&obj_type’,’TABLE’)||’%’)
order by object_name,owner
/
spool off