Nested Decodes Help

From: <battists_at_bsci.com>
Date: Sat, 02 Dec 2000 21:48:58 GMT
Message-ID: <90bqoa$pv3$1@nnrp1.deja.com>

Howdy folks,

I'm having some trouble with nested decodes. I have a Case statement from MS SQL server that I'm trying to translate into Oracle using nested decodes:

case when (a1.supervisor_id='1005940' and 'dirreps'='hrreps') then 'SUPER' when (a1.manager_id='1005940' and 'dirreps'='hrreps') then 'SUPERMAN' when (a1.hr_responsible_id='1005940' or 'hrreps'='hrreps') then 'HRMAN'

But I'm just not very familiar with nested decodes - I keep getting confused. (^_^) Any ideas as to how to approach this?

Steve Battisti

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Sat Dec 02 2000 - 15:48:58 CST