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 -> Diff bet'n DECODE and CASE stmt

Diff bet'n DECODE and CASE stmt

From: rohit <rohitk1973_at_yahoo.com>
Date: 11 Feb 2004 07:48:36 -0800
Message-ID: <74353ecc.0402110748.4525e477@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
Received on Wed Feb 11 2004 - 09:48:36 CST












Original text of this message













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