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