'Script, Query'에 해당되는 글 1건

  1. 2012.12.21 Hidden Parameter 조회

set linesize 200
col name for a30
col value for a30
col DESCRIPTION for a40
select x.ksppinm as Name ,y.ksppstvl as Value ,x.ksppdesc as Description
from x$ksppi x, x$ksppcv y
where x.indx = y.indx
and  x.ksppinm like '%&파라미터명%';

description이 보기 싫다 나는

set linesize 200
col name for a30
col value for a30
select x.ksppinm as Name ,y.ksppstvl as Value
from x$ksppi x, x$ksppcv y
where x.indx = y.indx
and  x.ksppinm like '%&파라미터명%';

Posted by neo-orcl
,