Display names of all views from Oracle database

Display names of all views from Oracle database

To display names of all views from Oracle database you can use: USER_VIEWS, ALL_VIEWS, DBA_VIEWS, USER_OBJECTS.

Examples

  
SELECT * FROM USER_VIEWS;

SELECT * FROM ALL_VIEWS;

SELECT * FROM DBA_VIEWS;

SELECT * FROM USER_OBJECTS WHERE OBJECT_TYPE='VIEW';

SELECT * FROM USER_OBJECTS 
WHERE OBJECT_TYPE='VIEW' AND ORACLE_MAINTAINED='N';