CrystalVis
Technical User
Can you please tell me if I can use <, >, or = operator in a DECODE statement. Example:
DECODE(tbl.Payment > 0, tbl.Payment, NULL)
or
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.
DECODE(tbl.Payment > 0, tbl.Payment, NULL)
or
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.