14 lines
439 B
SQL
14 lines
439 B
SQL
PROMPT Show system default compilation environment, parameter &1
|
|
|
|
SELECT
|
|
-- pnum_qkscesyrow
|
|
pname_qkscesyrow parameter
|
|
, DECODE(BITAND(flags_qkscesyrow, 2), 0, 'NO', 'YES') isdefault
|
|
, UPPER(pvalue_qkscesyrow) value
|
|
FROM x$qkscesys
|
|
WHERE
|
|
LOWER(pname_qkscesyrow) LIKE LOWER('%&1%')
|
|
-- BITAND(flags_qkscesyrow, 8) = 0
|
|
--AND (BITAND(flags_qkscesyrow, 4) = 0 OR BITAND(flags_qkscesyrow, 2) = 0)
|
|
/
|