Re: DECODE being depricated???

From: Martin Burbridge <pobox002_at_bebub.com>
Date: 21 Feb 2003 07:30:33 -0800
Message-ID: <45a06b65.0302210730.14572e31@posting.google.com>

Andrew Allen <andrew.allen_at_handleman.com> wrote in message news:<3E554DDB.3080000_at_handleman.com>...
> I have it hand written in my notes from the Oracle9i New Features For
> DBAs class -- which means the instructor said it. IIRC, DECODE will be
> around for a while but you should start using CASE (NULLIF and COALESCE
> too).
> --
> AjA
>
> Mike Cohen wrote:
> > Any idea why?
> >
> > Commencing in what version of Oracle?
> >
> > Man, just when I was getting good at it too!!! :(
> >
> > thanks,
> >
> > mike

Does anyone have a link to this in writing, such as release notes or Oracle docs. The SQL reference is usually pretty good about mentioning when things have been deprecated, but not a mention of it in the DECODE function documentation for 9iR2.

Considering you cannot use CASE in PL/SQL until 9iR1 it seems a bit early to start deprecating the alternative.

Martin Received on Fri Feb 21 2003 - 09:30:33 CST