VIEW: SYS.KU$_SWITCH_COMPILER_VIEW

Source

View Text - Preformatted

select /*+ no_merge */
         b.obj#, b.value, c.value, d.value, e.value, f.value, g.value
         FROM    sys.settings$ b, sys.settings$ c,  sys.settings$ d,
                 sys.settings$ e, sys.settings$ f,  sys.settings$ g,
                 sys.ku$_schemaobj_view o
         WHERE   o.obj_num  = b.obj# AND
                b.obj#  = c.obj# AND
                c.obj#  = d.obj# AND
                d.obj#  = e.obj# AND
                e.obj#  = f.obj# AND
                f.obj#  = g.obj# AND
                b.param = 'plsql_optimize_level'         AND
                c.param = 'plsql_code_type'              AND
                d.param = 'plsql_debug'                  AND
                e.param = 'plsql_ccflags'                AND
                f.param = 'plscope_settings'             AND
                g.param = 'nls_length_semantics'         AND
                (UID IN (o.owner_num, 0) OR
                 EXISTS (
                    SELECT  role
                    FROM    sys.session_roles
                    WHERE   role = 'SELECT_CATALOG_ROLE'))

View Text - HTML Formatted

SELECT /*+ NO_MERGE */ B.OBJ#
, B.VALUE
, C.VALUE
, D.VALUE
, E.VALUE
, F.VALUE
, G.VALUE
FROM SYS.SETTINGS$ B
, SYS.SETTINGS$ C
, SYS.SETTINGS$ D
, SYS.SETTINGS$ E
, SYS.SETTINGS$ F
, SYS.SETTINGS$ G
, SYS.KU$_SCHEMAOBJ_VIEW O
WHERE O.OBJ_NUM = B.OBJ# AND B.OBJ# = C.OBJ# AND C.OBJ# = D.OBJ# AND D.OBJ# = E.OBJ# AND E.OBJ# = F.OBJ# AND F.OBJ# = G.OBJ# AND B.PARAM = 'PLSQL_OPTIMIZE_LEVEL' AND C.PARAM = 'PLSQL_CODE_TYPE' AND D.PARAM = 'PLSQL_DEBUG' AND E.PARAM = 'PLSQL_CCFLAGS' AND F.PARAM = 'PLSCOPE_SETTINGS' AND G.PARAM = 'NLS_LENGTH_SEMANTICS' AND (UID IN (O.OWNER_NUM
, 0) OR EXISTS ( SELECT ROLE
FROM SYS.SESSION_ROLES
WHERE ROLE = 'SELECT_CATALOG_ROLE'))