Re: Decode

Jonathan Lewis wrote:
>
> 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
> >>

And interestingly the 9i documentation indicates that decode is "deprecated", which I typically read to mean "when we recode the 37654 decode statments in the data dictionary, we can get rid of it"

Cheers
Conno

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."