Oracle/SQL Query
[SQL] Hidden parameter 확인
천정현
2017. 4. 28. 17:24
select ksppinm name,
ksppstvl value,
ksppstdf is_default,
decode(bitand(ksppiflg/256,1),1,'true','false') ses_modifiable,
decode(bitand(ksppiflg/65536,3),1, 'immediate',2,'deferred',3,'immediate','false') sys_modifiable, ksppdesc description
from sys.x$ksppi i, sys.x$ksppcv v
where i.indx = v.indx;