复制col name format a25 col value format a10 select x.ksppinm name,必备知 y.kspftctxvl value, y.kspftctxdf isdefault, decode(bitand(y.kspftctxvf,7),1,MODIFIED,4,SYSTEM_MOD,FALSE) ismod, decode(bitand(y.kspftctxvf,2),2,TRUE,FALSE) isadj from sys.x$ksppi x, sys.x$ksppcv2 y where x.inst_id = userenv(Instance) and y.inst_id = userenv(Instance) and x.indx+1 = y.kspftctxpn and x.ksppinm like%omf% ; NAME VALUE ISDEFA ISMOD ISADJ ------------------------- ---------- ------ ---------- ----- _omf enabled TRUEFALSEFALSE 1.2.3.4.5.6.7.8.9.10.11.12.13.14.15.16.17.
亿华智慧云
