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 -> Re: Translate SQL Server CASE/ELSE (SELECT ..) into Oracle SQL?

Re: Translate SQL Server CASE/ELSE (SELECT ..) into Oracle SQL?

From: hpuxrac <johnbhurley_at_sbcglobal.net>
Date: 6 Jan 2006 11:25:59 -0800
Message-ID: <1136575559.825599.155050@g14g2000cwa.googlegroups.com> 





You may want to look at asktom.oracle.com he may have some material on
translating between the 2 dialects ( not sure ).



In general in oracle you don't want to do something in plsql if it can
be done in sql ( or done in oracle extensions to sql ).



As far as your question, nvl2 and decode are very handy functions plus
oracle does now support the case statement in sql depending on what
version the backend database is running in.
Received on Fri Jan 06 2006 - 13:25:59 CST












Original text of this message













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