Monday, July 8, 2013

SQL Query for finding table usages in the unknown packages or list of objects

  1. Find known table inside unknown package in plsql.
          select owner, name, referenced_owner, type from dba_dependencies where                                                              
          REFERENCED_NAME ='IBY_FNDCPT_PAYER_ASSGN_INSTR_V';

No comments:

Post a Comment