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

Home -> Community -> Usenet -> comp.databases.theory -> Re: How to use Decode function

Re: How to use Decode function

From: Bob Hairgrove <invalid_at_bigfoot.com>
Date: Sat, 25 Feb 2006 15:11:00 +0100
Message-ID: <h1p002phkvjvt696hl09vd2pqu86s0qb92@4ax.com>


On 25 Feb 2006 05:36:17 -0800, poojareddys_at_gmail.com wrote:

>Hi,
>
>Can anyone help me how to use DECODE function instead of CASE statement
>in the following query.
>

[snip]

I believe that DECODE is a function specific to Oracle, while CASE is standard SQL. Newer versions of Oracle probably support CASE, too. I only worked extensively with 8i and just a little with 9i; 8i didn't support CASE yet, IIRC. But they gave the SQL parser a major overhaul in 9i, and now it is much more standard than 8i was.

Maybe you would have more and better answers if you ask in comp.databases.oracle or comp.databases.oracle.server?

--
Bob Hairgrove
NoSpamPlease_at_Home.com
Received on Sat Feb 25 2006 - 08:11:00 CST

Original text of this message

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