select
substr(a.OWNER,1,20)
,
substr(a.NAME,1,30)
,
substr(a.TYPE,1,20)
,
substr(u.status,1,10) Stat
,
u.last_ddl_time
,
substr(text,1,80) Description
from
dba_source a, dba_objects u
WHERE
2=2
and
u.object_name = a.name
and
a.text like '%Header%'
and
a.type = u.object_type
and a.name
like 'AP_%API%' –- Checking for AP Related APIs
order by
a.owner,
a.name
No comments:
Post a Comment