Tuesday, October 16, 2018

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

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

SQL Important Queries

  How to delete rows with no where clause The following example deletes  all rows  from the  Person.Person  the table in the AdventureWork...