select DS.OWNER
, DS.NAME DS.TYPE
, DO.status
, DO.last_ddl_time
, DS.text Description
from dba_source DS, dba_objects DO
WHERE DO.object_name = DS.name
and DS.text like '%Header%'
and Ds.type = DO.object_type and DS.name like UPPER(:P_API_NAME) orderby DS.name
, DS.NAME DS.TYPE
, DO.status
, DO.last_ddl_time
, DS.text Description
from dba_source DS, dba_objects DO
WHERE DO.object_name = DS.name
and DS.text like '%Header%'
and Ds.type = DO.object_type and DS.name like UPPER(:P_API_NAME) orderby DS.name
No comments:
Post a Comment