Permalink
Switch branches/tags
Nothing to show
Find file Copy path
Fetching contributors…
Cannot retrieve contributors at this time
46 lines (45 sloc) 1.41 KB
----------------------------------------------------------------------------------------
--
-- File name: parmsd.sql
-- Purpose: Display parameters and descriptions.
-
-- Author: Kerry Osborne
--
-- Usage: This scripts prompts for one value which can be left blank.
--
-- name: the name (or piece of a name) of the parameter(s) you wish to see
--
---------------------------------------------------------------------------------------
set lines 155
col name for a50
col value for a30 trunc
col description for a50 wrap
col isdefault for a8
col ismodified for a10
col isset for a10
select name, value, description
from
(
select flag,name,value,isdefault,ismodified,
case when isdefault||ismodified = 'TRUEFALSE' then 'FALSE' else 'TRUE' end isset ,
description
from
(
select
decode(substr(i.ksppinm,1,1),'_',2,1) flag
, i.ksppinm name
, sv.ksppstvl value
, sv.ksppstdf isdefault
-- , decode(bitand(sv.ksppstvf,7),1,'MODIFIED',4,'SYSTEM_MOD','FALSE') ismodified
, decode(bitand(sv.ksppstvf,7),1,'TRUE',4,'TRUE','FALSE') ismodified
, i.KSPPDESC description
from sys.x$ksppi i
, sys.x$ksppsv sv
where i.indx = sv.indx
)
)
where name like nvl('%&parameter%',name)
and upper(isset) like upper(nvl('%&isset%',isset))
and flag not in (decode('&show_hidden','Y',3,2))
order by flag,replace(name,'_','')
/