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 'PA_%API%' 
order by 
a.owner, a.name;
 
No comments:
Post a Comment