Thursday, August 11, 2016

Query to get the list of Custom objects (TABLE, VIEW, PROCEDURE, FUNCTION AND PACKAGE)


select object_name, object_type
 from all_objects
 where 1=1
 and upper(object_type) IN ('FUNCTION','PACKAGE','PROCEDURE', 'VIEW', 'TABLE')
 and status='VALID'
 and object_name like 'XXCUST%'
order by 2;