SQL*Plus (MOSC)

MOSC Banner

how to not diplay all the negative values in my output

edited May 13, 2009 7:23PM in SQL*Plus (MOSC) 2 commentsAnswered ✓
 hi all,
i am newbie in programming now i do have a script to which have an output specified.
now i do want to not include all the negative values in my references amount,
have been trying to manipulate but unable to display the required fields,
heres the script that i am trying to work things out.
best wishes to everyone.

select distinct r.date_issued, r.cust_name, r.code, c.chk_no,
decode(c.item_no,1,p.ref_no, null)"REF_NO",
decode(c.item_no,1,p.ref_amt,null)"REF_AMT"
from sbis.receipts r, sbis.checks c, sbis.payments p

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center