Cheeky Cockatoo

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%')
/