Prompt

prompt +--------------------------------------+

prompt | Should be ran by sysdba user |

Prompt +--------------------------------------+

prompt

SET LINESIZE 145

SET PAGESIZE 9999

SET VERIFY off

COLUMN ksppinm FORMAT A42 HEAD 'Parameter Name'

COLUMN ksppstvl FORMAT A39 HEAD 'Value'

COLUMN ksppdesc FORMAT A60 HEAD 'Description' TRUNC

ksppinm

, ksppstvl

, ksppdesc

x$ksppi x

, x$ksppcv y

x.indx = y.indx

AND TRANSLATE(ksppinm,'_','#') like '#%'

and ksppinm LIKE NVL('%&parameter_name%', ksppinm);