col owner format a10 col object_name format a30 set verify off set lines 132 accept objname char default NONE prompt 'What is the object name : ' select owner, object_name, object_type,created, to_char(last_ddl_time,'mm/dd/yy hh24:mi'), status from dba_objects where object_name = upper('&objname') and upper('&objname') != 'NONE';