Re: Decode

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Sat, 6 Apr 2002 12:31:02 +0100
Message-ID: <1018092892.175.3.nnrp-10.9e984b29@news.demon.co.uk>

Unfortunately, CASE only exists in 8.1.6+.

Perhaps an upgrade to a supported version of Oracle would be in order anyway.

--
Jonathan Lewis
http://www.jlcomp.demon.co.uk

Next Seminar - UK, April 3rd - 5th
http://www.jlcomp.demon.co.uk/seminar.html

Host to The Co-Operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html

Author of:
Practical Oracle 8i: Building Efficient Databases


damorgan wrote in message <3CAA3761.6ADD73E3_at_exesolutions.com>...


>This is not a CASE for decode ... it is a case for CASE. You are using the

>wrong function.

>

>Daniel Morgan

>

>

>

>markag wrote:

>

>> Oracle 8.1.5, Windows

>>

Received on Sat Apr 06 2002 - 05:31:02 CST