rem -----------------------------------------------------------------------
rem Filename:   inithide.sql
rem Purpose:    List all un-supported INIT.ORA parameters
rem Date:       03-Apr-1998
rem Author:     Frank Naude (frank@onwe.co.za)
rem -----------------------------------------------------------------------

select a.ksppinm name, b.ksppstvl value, b.ksppstdf isdefault,
       decode(a.ksppity, 1, 'boolean', 2, 'string', 3, 'number', 4, 'file',
       a.ksppdesc) description
from   sys.x$ksppi a, sys.x$ksppcv b
where  a.indx = b.indx
  and  a.ksppinm like '\_%' escape '\'
order  by name
/