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: mssql server syntax equivalent for oracle

Re: mssql server syntax equivalent for oracle

From: Galen Boyer <galenboyer_at_yahoo.com>
Date: 13 Apr 2001 10:38:13 -0500
Message-ID: <ug0fc7qsb.fsf@yahoo.com>

On Fri, 13 Apr 2001, nomail_at_hips.doc wrote:

> hello,
>
> i'm trying to port an sql order from SQL Server to Oracle...and
> i have some trouble
>
> what would be the "Oracle" translation of the following "case"
> select ?
>
> SELECT CUSTOMERID,
> case when CUSTNAME is null then "no name"
> else CUSTNAME as NAME
> end
> FROM CUSTOMERS
>
> any help would be greatly appreciated
> Christian

Look up the "decode" statement and see what you can come up with.

-- 
I don't want to be the rock.  Yeah, okay, what do you want to be?
I want to be the piece of glass.
Received on Fri Apr 13 2001 - 10:38:13 CDT

Original text of this message

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