Monday, October 23, 2017

Query To get all the Views that refer a particular Table

SELECT o.object_name, o.status, o.last_ddl_time
  FROM SYS.dba_objects o
 WHERE     o.object_type = 'VIEW'
       AND EXISTS
              (SELECT 'x'
                 FROM SYS.dba_dependencies d
                WHERE     d.referenced_type = 'TABLE'
                      AND d.TYPE = 'VIEW'
                      AND d.owner = 'APPS'
                      AND d.NAME = o.object_name
                      AND d.referenced_name LIKE '<TABLE_NAME>');

No comments:

Post a Comment

Query to get the Concurrent Program along with Value Set details

SELECT fcpl1.user_concurrent_program_name       ,fdfcuv.end_user_column_name       ,ffvs.flex_value_set_name value_set_name       ,ffvt.appl...