DECODE(tbl.Payment > 0, tbl.Payment, NULL)
DECODE(tbl.Payment, tbl.Payment > 0, tbl.Payment, NULL)
DECODE(tbl.Payment, > 0 tbl.Payment, NULL)
None of these statement work!!! I understand the DECODE statement but can't seems to get the stored proc to compile because of the DECODE statement.
DECODE(expr, cond1, val1, cond2, val2...def)
by the way, the database is Oracle 8. Your help is greatly appreciated.