01 March 2016

Oracle SQL to find the dependencies of an Object/Table

User following SQL to find the dependencies of an object/ta ble.


SELECT
  *
FROM
  sys.dba_dependencies
WHERE
  1                         =1
-- AND referenced_type = 'TABLE'
AND referenced_owner        = 'APPS'
AND UPPER(referenced_name) IN UPPER('XXINV_ITEMS_OUTBOUND_STG');

2 comments:

oracle Ebs training said...

Hi,
this blog was an excellent contribution to the oracle community, I think are basic but very useful things, I congratulate you and the reason to keep going.
Oracle Financials training
Thank you.

Aravindmudraveni said...
This comment has been removed by the author.