set ver off; select owner,object_type,object_name,status,created,last_ddl_time from dba_objects where object_name like upper('%&1%'); set ver on;