You can use the following views to return a list of views in Oracle Database.
The user_views
View
The user_views
data dictionary view describes the views owned by the current user:
SELECT view_name
FROM user_views;
If you need the view definition, include the text
column in your query.
As mentioned, this returns only those views that are owned by the current user.
To return more than that, use one of the following views.
The all_views
View
The all_views
data dictionary view describes the views accessible to the current user:
SELECT view_name
FROM all_views;
As with user_views
, if you need the view definition, include the text
column in your query.
The dba_views
View
The dba_views
data dictionary view describes all views in the database:
SELECT view_name
FROM all_views;
Note that you need dba privileges for this query.
If you need the view definition, include the text
column in your query.