What do you want to save?
Add Code snippet
New code examples
-
-
SQL 2021-09-14 08:31:03
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_VIEW... Add solution