col name for a32
col value for a24
col description for a70
select a.ksppinm name,b.ksppstvl value,a.ksppdesc description from x$ksppi
a,x$ksppcv b where a.inst_id = USERENV ('Instance') and b.inst_id = USERENV
('Instance') and a.indx = b.indx and upper(a.ksppinm) LIKE upper('%露 m%') order
by name
/
set linesize 333
set pagesize 333;
col name for a35
col description for a66
col value for a30
SELECT i.ksppinm name,
--i.ksppdesc description,
CV.ksppstvl VALUE
FROM sys.x$ksppi i, sys.x$ksppcv CV
WHERE i.inst_id = USERENV ('Instance')
AND CV.inst_id = USERENV ('Instance')
AND i.indx = CV.indx
AND i.ksppinm LIKE '/_mv%' ESCAPE '/'
ORDER BY REPLACE (i.ksppinm, '_', '');
评论