Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Question on Decode Versus Case

Question on Decode Versus Case

From: Tim Marshall <TIMMY!_at_PurplePandaChasers.Moertherium>
Date: Fri, 16 Sep 2005 17:32:29 -0230
Message-ID: <dgf8cm$cis$1@coranto.ucs.mun.ca>


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.

-- 
Tim    http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Whatcha doin?" - Ditto  "TIM-MAY!!" - Me
Received on Fri Sep 16 2005 - 15:02:29 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US