VIEW: SYS.EXU8CPO

Source

View Text - Preformatted

SELECT  parameter, DECODE(value, 'TRUE', 1, 'FALSE', 0, 2)
        FROM    sys.v$option
        WHERE   parameter IN ('procedural', 'replication')

View Text - HTML Formatted

SELECT PARAMETER
, DECODE(VALUE
, 'TRUE'
, 1
, 'FALSE'
, 0
, 2)
FROM SYS.V$OPTION
WHERE PARAMETER IN ('PROCEDURAL'
, 'REPLICATION')