Got this one from
somebody, don't remember who, though...
select rpad (a.indx ,10) "number"
,rpad
(b.KSPPINM ,50) "name"
, rpad (a.KSPPSTVL,50) "value"
, rpad (a.KSPPSTDF,10) "default"
from x$KSPPCV a
, X$KSPPI b
where a.indx = b.indx;
HTH,
Mandar.
-Original Message-From:
).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mandar Shete
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mandar Shete
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
://www.planetm.co.in/A
--=_MAILER_ATTACH_BOUNDARY1_2001102321319121061730690--
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mandar Shete
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet
://www.planetm.co.in/A
--=_MAILER_ATTACH_BOUNDARY1_200110221181548701943705--
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mandar Shete
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet
--
Author: Mandar Shete
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) S8-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing
://www.planetm.co.in
--=_MAILER_ATTACH_BOUNDARY1_200110221181548701943705--
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mandar Shete
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access
related information.
hope this helps.
Prasad
Mandar Shete
times.comgt; cc:
Sent by: Subject: Export Hanging
[EMAIL PROTECTED]
10/22/2001 09:50 AM
Please respond to
ORACLE-L
--=_MAILER_ATTACH_BOUNDARY1_200110221181548701943705
Content-Type: text/plain; charset=us-ascii
Hi All
Accessories from A
href=http://www.planetm.co.in;http://www.planetm.co.in/A
--=_MAILER_ATTACH_BOUNDARY1_20011011191633294702567--
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mandar Shete
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX