Skip to Main Content
Forums

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!

alternate for NVL2

DBA_1976Nov 23 2009 — edited Nov 23 2009
Hi,
I know how NVL works. But I have a need to evaluate for 0 instead of Null. Is there a way to do that.


I need to select col1. But If col1 is 0 then I need to select col2 and this has to be done in a single select statement. Could this be done?
This post has been answered by 730428 on Nov 23 2009
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 21 2009
Added on Nov 23 2009
4 comments
429 views