Re: Oracle Discover - Decode
From: Mike Dwyer <dwyermj_at_co,larimer.co.us>
Date: Thu, 12 Oct 2000 08:39:34 -0600
Message-ID: <88kF5.46$cS1.9010_at_wdc-read-01.qwest.net>
Date: Thu, 12 Oct 2000 08:39:34 -0600
Message-ID: <88kF5.46$cS1.9010_at_wdc-read-01.qwest.net>
select decode( sign(&n-330), -1,'below', 'above') from dual;
"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 Thu Oct 12 2000 - 16:39:34 CEST