Histórico da Página

CREATE VIEW ALL_OBJECTS AS
SELECT * FROM SYS.ALL_OBJECTS
WHERE OWNER = sys_context('USERENV', 'CURRENT_SCHEMA');

CREATE VIEW ALL_SYNONYMS AS
SELECT * FROM SYS.ALL_SYNONYMS
WHERE OWNER = sys_context('USERENV', 'CURRENT_SCHEMA');

CREATE VIEW ALL_SEQUENCES AS
SELECT * FROM SYS.ALL_SEQUENCES
WHERE SEQUENCE_OWNER = sys_context('USERENV', 'CURRENT_SCHEMA');

CREATE VIEW ALL_CONSTRAINTS AS
SELECT * FROM SYS.ALL_CONSTRAINTS
WHERE OWNER = sys_context('USERENV', 'CURRENT_SCHEMA');

CREATE VIEW ALL_CONS_COLUMNS AS
SELECT * FROM SYS.ALL_CONS_COLUMNS
WHERE OWNER = sys_context('USERENV', 'CURRENT_SCHEMA');

CREATE VIEW ALL_INDEXES AS
SELECT * FROM SYS.ALL_INDEXES
WHERE OWNER = sys_context('USERENV', 'CURRENT_SCHEMA');

CREATE VIEW ALL_IND_COLUMNS AS
SELECT * FROM SYS.ALL_IND_COLUMNS
WHERE TABLE_OWNER = sys_context('USERENV', 'CURRENT_SCHEMA');

CREATE VIEW ALL_TABLES AS
SELECT * FROM SYS.ALL_TABLES
WHERE OWNER = sys_context('USERENV', 'CURRENT_SCHEMA');

CREATE VIEW ALL_TAB_COLUMNS AS
SELECT * FROM SYS.ALL_TAB_COLUMNS
WHERE OWNER = sys_context('USERENV', 'CURRENT_SCHEMA');