List views in Oracle database – Oracle Query Toolbox
Posted by jpluimers on 2021/06/03
[WayBack] List views in Oracle database – Oracle Query Toolbox
A. All views accessible to the current user
select owner as schema_name, view_name from sys.all_views order by owner, view_name;B. If you have privilege on dba_views
select owner as schema_name, view_name from sys.dba_views order by owner, view_name;
(more details in the above post)
–jeroen
Leave a Comment