1 2 3 4 5 6 7 8 9 | SELECT SYN.SYNONYM_NAME apex_view_name FROM all_synonyms syn, all_views av, apex_dictionary ad WHERE syn.synonym_name LIKE 'APEX\_%' ESCAPE '\' AND syn.owner = ' PUBLIC ' AND SYN.TABLE_NAME = AV.VIEW_NAME AND SYN.SYNONYM_NAME = AD.APEX_VIEW_NAME(+) AND ad.column_id IS NULL ORDER BY syn.synonym_name |
Tuesday, July 13, 2010
Missing Views from the APEX_DICTIONARY
A long time ago I wrote about how you can list all the apex views by querying APEX_DICTIONARY. They're some views that are still public but are not listed in the Apex Dictionary. The following query lists these views
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment