Re: Oracle Discover - Decode
From: Matt B. <mcb_at_fightspam.sd.znet.com>
Date: Tue, 10 Oct 2000 20:30:01 -0700
Message-ID: <su7ncuiabikr00_at_corp.supernews.com>
Date: Tue, 10 Oct 2000 20:30:01 -0700
Message-ID: <su7ncuiabikr00_at_corp.supernews.com>
"LMoscarito" <lmoscarito_at_aol.com> wrote in message
news:20001010221004.20940.00001332_at_ng-fg1.aol.com...
> I wanted to use decode to create aging columns for invoices.
> I can do it whenit equals values, however I wanted to end it with a range
> over 330 days. But decode will not accept >.
> Does any one know a work around.
> ex decode(trunc((sysdate-receipt_date)/30)>5, amount,null) over330
> I read you can use sign but do not know how.
> Thanks,
> Joe
Received on Wed Oct 11 2000 - 05:30:01 CEST