Skip to Main Content

Database Software

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Please make NVL2 available in PL/SQL

ApexBineNov 25 2019 — edited May 8 2020

NVL2 is precise and it's shorter than the corresponding case expression.

I can't see a reason why it should be available in SQL only.

NVL2 SQL doc:

https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/NVL2.html#GUID-414D6E81-9627-4163-8AC2-BD24E57742AE

If you can't resist, feel free to post your workarounds, but please don't forget to vote up

(Yes, writing my own NVL2 is workaround #1.)

NVL2 for PL/SQL has been implemented in Oracle Database 20c.

Comments

Post Details

Added on Nov 25 2019
5 comments
488 views