Oracle Views

These are queries that you can used to display the views on Oracle.

• ALL_VIEWS describes the views accessible by logged user.

select * from all_views

• DBS_VIEWS describes all views however you need DBA priviledges for this query.

select *  from dba_views

• USER_VIEWS describes the views owned by logged user.

select *  from user_views

Also you could look at standard INFORMATION_SCHEMA.VIEWS first (they exists in any RDBMS, eg. Oracle, MySQL, SQL Server, etc), there are lot of information about your database.