DBA Data[Home] [Help]

VIEW: SYS.EXU10DEFPSWITCHES

Source

View Text - Preformatted

SELECT  a.value, b.value, c.value
        FROM    sys.v$parameter a, sys.v$parameter b, sys.v$parameter c
        WHERE   a.name = 'plsql_compiler_flags' AND
                b.name = 'nls_length_semantics' AND
                c.name = 'plsql_optimize_level'
View Text - HTML Formatted

SELECT A.VALUE
, B.VALUE
, C.VALUE
FROM SYS.V$PARAMETER A
, SYS.V$PARAMETER B
, SYS.V$PARAMETER C
WHERE A.NAME = 'PLSQL_COMPILER_FLAGS' AND B.NAME = 'NLS_LENGTH_SEMANTICS' AND C.NAME = 'PLSQL_OPTIMIZE_LEVEL'