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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Diff bet'n DECODE and CASE stmt

Re: Diff bet'n DECODE and CASE stmt

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Wed, 11 Feb 2004 17:47:07 +0100
Message-ID: <402a5c21$0$28152$626a14ce@news.free.fr>

"rohit" <rohitk1973_at_yahoo.com> a écrit dans le message de news:74353ecc.0402110748.4525e477_at_posting.google.com...
> What is the difference between Decode and Case statements when used in
> a SQL query? The two appear to do the same IF-THEN-ELSE logic, I am
> not sure how the optimizer treats the two. Any explanation on how the
> optimizer uses the two would be super.
>
> Mucho thanks,
> Rohit

Decode existed before case.
Case is much easier to use but...
as i have used decode for more than 10 years, i continue to use it :)

Regards
Michel Cadot Received on Wed Feb 11 2004 - 10:47:07 CST

Original text of this message

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