List views in Oracle database

Query below lists:

(A) all views accessible to the current user in Oracle database

(B) all views in Oracle database

Query was executed under the Oracle12c Database version.

Query

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;

Columns

  • schema_name - view owner, schema name
  • view_name - view name

Rows

  • One row represents one view in a database
  • Scope of rows: (A) all views accessible to the current user in Oracle database, (B) all views in Oracle database
  • Ordered by schema name, view name

Sample results

Here is a view of database views in Oracle SQL Developer: