SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to use NVL function in the Decode ?

994122Jul 2 2014 — edited Jul 2 2014

Hi all,

How to use NVL function in the Decode ?

SELECT Decode(Sign(sum(nvl(7),0) - nvl(sum(5),0)), -1, 0,(sum(nvl(7),0) - nvl(sum(5),0)) QTY

from dual

Thanks

This post has been answered by RogerT on Jul 2 2014

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 30 2014

Added on Jul 2 2014

5 comments

2,798 views