** if you want to know the package body, procedure or function that have the object referenced to , you can use **
select referenced_owner, referenced_name, referenced_type from user_dependencies where name = 'XXXXMGMT';
XXXXMGR XXXX_HISTORY TABLE
YYYYMGR XXXX_MGMG PACKAGE
XXXXMGR XXXX_SENDNPM TABLE
XXXXMGR XXXX_CUSTOMER TABLE
XXXXMGR XXXX_SWAPLOGIN FUNCTION
XXXXMGR XXXX TABLE
XXXXMGR XXXX_CUSTOMER TABLE
XXXXMGR XXXX_LOGIN NON-EXISTENT
-- OR --
** if you want to know which object_name reference to table, you this command **
select name,type from user_dependencies where referenced_name = 'XXXX_CUSTOMER'
YYYYMGMT PACKAGE
YYYYMGMT PACKAGE
ZZZZMGMT PACKAGE BODY
ZZZZMGMT PACKAGE BODY
== TaTsHuYa ==
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment