select * from (SELECT pin.ksppinm called, pcv.ksppstvl itsvalue
FROM SYS.x$ksppi pin, SYS.x$ksppcv pcv
WHERE pin.inst_id = USERENV ('Instance')
AND pcv.inst_id = pin.inst_id
AND pin.indx = pcv.indx
AND pin.ksppinm LIKE '\_%' ESCAPE '\') where upper(called) like
'%OPTI%';
No comments:
Post a Comment