Histórico da Página
...
Bloco de código | ||
---|---|---|
| ||
DECLARE CREATE AUX_USERCONNECTED VARCHAR2(30); BEGIN SELECT SYS_CONTEXT('USERENV', 'CURRENT_SCHEMA') INTO AUX_USERCONNECTED FROM DUAL; IF (AUX_USERCONNECTED <> 'SYS') AND (AUX_USERCONNECTED <> 'SYSTEM') THEN EXECUTE IMMEDIATE ('CREATEOR REPLACE VIEW ALL_OBJECTS AS' || ' SELECT * FROM SYS.ALL_OBJECTS WHERE OWNER =' || ' SYS_CONTEXT(' || CHR(39) || 'USERENV' || CHR(39) || ', ' || CHR(39) || 'CURRENT_SCHEMA' || CHR(39) || ')'); EXECUTE IMMEDIATE ('CREATEIN (SELECT USER FROM DUAL); CREATE OR REPLACE VIEW ALL_SYNONYMS AS' || ' SELECT * FROM SYS.ALL_SYNONYMS WHERE OWNER =' || ' SYS_CONTEXT(' || CHR(39) || 'USERENV' || CHR(39) || ', ' || CHR(39) || 'CURRENT_SCHEMA' || CHR(39) || ')'); EXECUTE IMMEDIATE ('CREATE IN (SELECT USER FROM DUAL); CREATE OR REPLACE VIEW ALL_SEQUENCES AS' || ' SELECT * FROM SYS.ALL_SEQUENCES WHERE SEQUENCE_OWNER =' || ' SYS_CONTEXT(' || CHR(39) || 'USERENV' || CHR(39) || ', ' || CHR(39) || 'CURRENT_SCHEMA' || CHR(39) || ')'); EXECUTE IMMEDIATE ('CREATEIN (SELECT USER FROM DUAL); CREATE OR REPLACE VIEW ALL_CONSTRAINTS AS' || ' SELECT * FROM SYS.ALL_CONSTRAINTS WHERE OWNER =' || ' SYS_CONTEXT(' || CHR(39) || 'USERENV' || CHR(39) || ', ' || CHR(39) || 'CURRENT_SCHEMA' || CHR(39) || ')'); EXECUTE IMMEDIATE ('CREATEIN (SELECT USER FROM DUAL); CREATE OR REPLACE VIEW ALL_CONS_COLUMNS AS' || ' SELECT * FROM SYS.ALL_CONS_COLUMNS WHERE OWNER =' || ' SYS_CONTEXT(' || CHR(39) || 'USERENV' || CHR(39) || ', ' || CHR(39) || 'CURRENT_SCHEMA' || CHR(39) || ')'); EXECUTE IMMEDIATE ('CREATE IN (SELECT USER FROM DUAL); CREATE OR REPLACE VIEW ALL_INDEXES AS' || ' SELECT * FROM SYS.ALL_INDEXES WHERE OWNER =' || ' SYS_CONTEXT(' || CHR(39) || 'USERENV' || CHR(39) || ', ' || CHR(39) || 'CURRENT_SCHEMA' || CHR(39) || ')'); EXECUTE IMMEDIATE ('CREATEIN (SELECT USER FROM DUAL); CREATE OR REPLACE VIEW ALL_IND_COLUMNS AS' || ' SELECT * FROM SYS.ALL_IND_COLUMNS WHERE TABLE_OWNER =' || ' SYS_CONTEXT(' || CHR(39) || 'USERENV' || CHR(39) || ', ' || CHR(39) || 'CURRENT_SCHEMA' || CHR(39) || ')'); EXECUTE IMMEDIATE ('CREATE IN (SELECT USER FROM DUAL); CREATE OR REPLACE VIEW ALL_TABLES AS' || ' SELECT * FROM SYS.ALL_TABLES WHERE OWNER =' || ' SYS_CONTEXT(' || CHR(39) || 'USERENV' || CHR(39) || ', ' || CHR(39) || 'CURRENT_SCHEMA' || CHR(39) || ')'); EXECUTE IMMEDIATE ('CREATEIN (SELECT USER FROM DUAL); CREATE OR REPLACE VIEW ALL_TAB_COLUMNS AS' || ' SELECT * FROM SYS.ALL_TAB_COLUMNS WHERE OWNER =' || ' SYS_CONTEXT(' || CHR(39) || 'USERENV' || CHR(39) || ', ' || CHR(39) || 'CURRENT_SCHEMA' || CHR(39) || ')'); END IF; END; |
Você pode baixar o script aqui.
...
IN (SELECT USER FROM DUAL); |
Oracle 12c
Caso seja utilizado Oracle 12c ou superior é necessário alterar o arquivo <INSTALL_FLUIG>\jboss\bin\standalone.conf.bat(standalone.conf em ambientes Linux) e incluir a seguinte linha:
...
Visão Geral
Import HTML Content
Conteúdo das Ferramentas
Tarefas