this should be run as sys
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 '_improved%'
order by name;
reference:
http://database.itags.org/oracle/122568/
https://forums.oracle.com/forums/thread.jspa?threadID=295697&messageID=3166221
No comments:
Post a Comment