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.