SQL> set linesize 150; SQL> col name for a30; SQL> col value for a10; SQL> 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 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 =‘_lm_tickets‘ order by translate(x.ksppinm, ‘ _‘, ‘ ‘) / NAME VALUE ISDEFAULT ISMOD ISADJ ------------------------------ ---------- ------------------ -------------------- ---------- _lm_tickets 1000 TRUE FALSE FALSE
注:
1、如查询其他参数,只需要把标红的_lm_tickets,换成你要查询的参数即可。