Sunday, October 19, 2014

Script To get Oracle API’s for any module



Here is the script used to get the API’s for any module


select a.owner, a.name, a.type,
          u.status Status, u.last_ddl_time,
          substr(text, 1, 80) Description
   from dba_source a, dba_objects u
 where u.object_name = a.name
    and a.text like '%Header%'
    and a.type = u.object_type
    and a.name like 'AR_%API%' -- you can changed module wise
  order by a.owner, a.name;