1SELECT * FROM USER_VIEWS; -- Views from connected schema
2SELECT * FROM ALL_VIEWS; -- Views available to connected schema
3 SELECT * FROM ALL_VIEWS WHERE OWNER = 'SCHEMA_NAME';
4 SELECT * FROM ALL_VIEWS WHERE VIEW_NAME = 'VIEW_NAME';
5SELECT * FROM DBA_VIEWS; -- All database Views