Árvore de páginas

Versões comparadas

Chave

  • Esta linha foi adicionada.
  • Esta linha foi removida.
  • A formatação mudou.

...

Bloco de código
languagesql
CREATE OR REPLACE VIEW ALL_OBJECTS AS SELECT * FROM SYS.ALL_OBJECTS WHERE OWNER IN (SELECT USER FROM DUAL);
CREATE OR REPLACE VIEW ALL_SYNONYMS AS SELECT * FROM SYS.ALL_SYNONYMS WHERE OWNER IN (SELECT USER FROM DUAL);
CREATE OR REPLACE VIEW ALL_SEQUENCES AS SELECT * FROM SYS.ALL_SEQUENCES WHERE SEQUENCE_OWNER IN (SELECT USER FROM DUAL);
CREATE OR REPLACE VIEW ALL_CONSTRAINTS AS SELECT * FROM SYS.ALL_CONSTRAINTS WHERE OWNER IN (SELECT USER FROM DUAL);
CREATE OR REPLACE VIEW ALL_CONS_COLUMNS AS SELECT * FROM SYS.ALL_CONS_COLUMNS WHERE OWNER IN (SELECT USER FROM DUAL);
CREATE OR REPLACE VIEW ALL_INDEXES AS  SELECT * FROM SYS.ALL_INDEXES WHERE OWNER IN (SELECT USER FROM DUAL);
CREATE OR REPLACE VIEW ALL_IND_COLUMNS AS  SELECT * FROM SYS.ALL_IND_COLUMNS WHERE TABLE_OWNER IN (SELECT USER FROM DUAL);
CREATE OR REPLACE VIEW ALL_TABLES AS SELECT * FROM SYS.ALL_TABLES WHERE OWNER IN (SELECT USER FROM DUAL);
CREATE OR REPLACE VIEW ALL_TAB_COLUMNS AS SELECT * FROM SYS.ALL_TAB_COLUMNS WHERE OWNER IN (SELECT USER FROM DUAL);

...