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
,