Of course, had you looked at the script before you executed it, and then
made sure that you understood what it was doing, you would never have given
yourself such a fright.
Thank you,
Paul Sherman
DBA
voice - 781-501-4143 (office)
fax- 781-278-8341 (office)
email - [EMAIL PROTECTED]
Thanks!
This gives the correct information.
I guess I'm inclined to trust anything from ixora blindly :)
Jay Miller
-Original Message-
Sent: Friday, January 18, 2002 4:56 PM
To: Multiple recipients of list ORACLE-L
You are not reading the value.
Try this:
select a.INDX NUM, a.KSP
You are not reading the value.
Try this:
select a.INDX NUM, a.KSPPINM NAME, a.KSPPITY TYPE, a.KSPPDESC
DESCRIPTION, b.KSPPSTVL VALUE, b.KSPPSTDF ISDEFAULT
from sys.X_$KSPPI a, sys.X_$KSPPCV b
where a.indx = b.indx and a.ksppinm like '%trig%'
order by 2
-Original Message-