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.