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>


[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

Original text of this message