oracle 查询入参写法,ORACLE隐参查询

set linesize 200;

col name for a30;

col value for a10;

col ismodified for a10;

col isdefault for a10;

col description for a75;

select

i.ksppinm name,

i.ksppdesc description,

cv.ksppstvl value,

cv.ksppstdf isdefault,

decode(bitand(cv.ksppstvf,7),1,’MODIFIED’,4,’SYSTEM_MOD’,’FALSE’) ismodified,

decode(bitand(cv.ksppstvf,2),2,’TRUE’,’FALSE’) isadjusted from

sys.x$ksppi i,

sys.x$ksppcv cv

where

i.inst_id=userenv(‘Instance’) and

cv.inst_id=userenv(‘Instance’) and

i.indx=cv.indx and

i.ksppinm like ‘%&GetHidPar%’;