Tim Marshall wrote:
> DA Morgan gave me an example of a procedure in another thread (Unions
> With Grouping Group Values) in which he uses the decode function. In my
> reference book I'm using for my Oracle SQL, and now some of the PL/SQL I
> am learning on my own, the author stated "Oracle is planning to drop the
> DECODE function in future releases and to replace the function with the
> CASE statement...."
>
> The book was written around Oracle 9i and published in 2003. Is this
> statement still true (if it ever was) or is it safe to use DECODE? I've
> been deliberately using CASE statements on my SQL statements because of
> the point made by the book. We're still on Oracle 8i, but will
> doubtless be progressing eventually to 10 and later versions.
>
> Thanks in advance.
Oracle will not drop DECODE anytime in the next 5-10 years for the
simple reason Doug states. But CASE is also available and the same
solution can be done in either.
--
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Sat Sep 17 2005 - 00:05:37 CDT
