西湖鱼 发表于 2018-9-12 10:59:07

oracle查看隐含参数脚本

set linesize 132  
column name format a30
  
column value format a25
  
select
  
x.ksppinmname,
  
y.ksppstvlvalue,
  
y.ksppstdfisdefault,
  
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 like '%_&par%'
  
order by
  
translate(x.ksppinm, ' _', ' ')
  
/


页: [1]
查看完整版本: oracle查看隐含参数脚本