15 May, 2015

SQL Query for List of API's in APPS

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

No comments:

Post a Comment

OEM Agent Installation

./agentDeploy.sh AGENT_BASE_DIR=/u001/oracle/product/agent13c OMS_HOST=oem-dev.xxx.com EM_UPLOAD_PORT=1159 AGENT_REGISTRATION_PASSWORD=*****...