oracle owner view
SELECT * FROM USER_VIEWS; -- Views from connected schema
SELECT * FROM ALL_VIEWS; -- Views available to connected schema
SELECT * FROM ALL_VIEWS WHERE OWNER = 'SCHEMA_NAME';
SELECT * FROM ALL_VIEWS WHERE VIEW_NAME = 'VIEW_NAME';
SELECT * FROM DBA_VIEWS; -- All database Views
Are there any code examples left?
New code examples in category SQL