Oracle Discover - Decode
From: LMoscarito <lmoscarito_at_aol.com>
Date: 11 Oct 2000 02:10:04 GMT
Message-ID: <20001010221004.20940.00001332_at_ng-fg1.aol.com>
Date: 11 Oct 2000 02:10:04 GMT
Message-ID: <20001010221004.20940.00001332_at_ng-fg1.aol.com>
[Quoted] [Quoted] I wanted to use decode to create aging columns for invoices.
[Quoted] 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 - 04:10:04 CEST