Find the editioning views for tables

by Granville Bonyata on June 7, 2012

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 b.name = a.view_name
AND b.type = 'VIEW'
AND a.editioning_view = 'Y';

Previous post:

Next post: