MSSQL Case equiv in Oracle (8.1.7.2.0)

From: James <jtait12_at_hotmail.com>
Date: 18 Jan 2004 15:02:55 -0800
Message-ID: <5bcd1cba.0401181502.7639a849@posting.google.com>

Hi all,

I am trying to port the query below from an MSSQL 2000 server to an ORACLE 8.1.7.2.0 server. I assume i need to use the DECODE command but i just cant seem to get it working... any help would be great!

<code start>

SELECT priority = CASE WHEN priority = '04-Medium' AND severity = '99' THEN 'URGENT'

                       ELSE priority
                  END

FROM table_case
<code end>
Received on Sun Jan 18 2004 - 17:02:55 CST