oracle owner view

Solutions on MaxInterview for oracle owner view by the best coders in the world

showing results for - "oracle owner view"
Maria
19 Jul 2020
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