隠しParameter記述表示
col NAME format a20;
col VALUE format a20;
col DESCRIB format a100;
SELECT
    x.ksppinm NAME,y.ksppstvl VALUE,x.ksppdesc DESCRIB
FROM
    sys.x$ksppi x,sys.x$ksppcv y
WHERE
    x.inst_id = USERENV('Instance')
AND y.inst_id = USERENV('Instance')
AND x.indx = y.indx
AND x.ksppinm LIKE '%&hiddenParam%'
Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License