oracle 10g所有的隐含参数及相关参数含义说明

col name  for a10
col value for a10
col des   for a50

select x.ksppinm name, y.ksppstvl value, x.ksppdesc des
from x$ksppi x,x$ksppcv y
where x.indx=y.indx
order by replace(x.ksppinm,'_','')
/

set linesize 132
col name for a30
col value for a25

select
    x.ksppinm name,
    y.ksppstvl value,
    y.ksppstdf isdefault,
    decode(bitand(y.ksppstvf, 7), 1, 'modified', 4, 'system_mod', 'FALSE') ismod,
    decode(bitand(y.ksppstvf, 2), 2, 'TRUE', 'FALSE') isadj
from x$ksppi x, x$ksppcv y
where x.inst_id = userenv('instance')
and y.inst_id=userenv('instance')
and x.indx = y.indx
and x.ksppinm like '%_&par%'
order by translate (x.ksppinm, '_', '');

--and x.ksppinm like '*_&par%' escape '*'
escape '*'：表示*后面的_不当作（单字符通配符）特殊字符处理，认为是正常的_下划线

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/7446963/viewspace-700458/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/7446963/viewspace-700458/