set line 120 set pagesize 50 col name for a20 col value for a10 col deflt for a10 col type for a10 col description for a50 select a.ksppinm name, b.ksppstvl value,b.ksppstdf deflt, decode (a.ksppity, 1, 'boolean', 2, 'string', 3, 'number', 4, 'file', a.ksppity) type, 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 ..