隠し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%'
page revision: 1, last edited: 10 Jul 2008 10:07