Re: trivial decode NOT
From: Venky Potdar <venky_patdar_at_ccmgw.bal.mmc.com>
Date: 1995/04/10
Message-ID: <3mbnt3$1nq_at_theopolis.orl.mmc.com>#1/1
Date: 1995/04/10
Message-ID: <3mbnt3$1nq_at_theopolis.orl.mmc.com>#1/1
In article <D6L1J7.KBq_at_gremlin.nrtc.northrop.com>, maurit_at_world.nad.northrop.com (Mark W. Aurit) says:
>
>
The code is something like this
select decode(sign(acct-120),1,decode(acct-140),-1,'Labor'),second decode
from tablename
Received on Mon Apr 10 1995 - 00:00:00 CEST