June 2012

Find the editioning views for tables

Here’s a quick query to find the editioning view for a table: SELECT a.* FROM dba_views a, dba_dependencies b WHERE b.name = a.view_name   AND a.editioning_view = ‘Y’   AND b.referenced_name ‘EMPLOYEE_TABLE’; And going the other direction, get the table the view is based on: SELECT b.referenced_name   FROM dba_views a, dba_dependencies b WHERE b.name = ‘EMPLOYEE_TABLE_VIEW’ AND […]

Read more →