Cheeky Cockatoo

Life Advice and Stories, Travel, Oracle Tech, Good Food and More

sel_obj.sql

Download Script

set linesize 132
col object_name format a30 trunc
col tablespace_name format a30
select owner, object_name, object_type, status, created
from dba_objects
where object_name like upper('%&object_name%')
/