Tags
#null
Question

Oracle NVL2() function and CASE expression

The NVL2() function is logically equivalent to the following CASE expression:

 CASE WHEN e1 IS NOT NULL THEN e2 ELSE e3 END

Tags
#null
Question

Oracle NVL2() function and CASE expression

The NVL2() function is logically equivalent to the following CASE expression:

?

Tags
#null
Question

Oracle NVL2() function and CASE expression

The NVL2() function is logically equivalent to the following CASE expression:

 CASE WHEN e1 IS NOT NULL THEN e2 ELSE e3 END
If you want to change selection, open document below and click on "Move attachment"

Oracle NVL2 Function By Practical Examples
ction to implement a logic that if the commission IS NOT NULL, then the total compensations is just salary. In case the commission IS NULL, calculate the full payment as salary plus commission. <span>Oracle NVL2() function and CASE expression The NVL2() function is logically equivalent to the following CASE expression: 1 2 3 4 5 6 CASE WHEN e1 IS NOT NULL THEN e2 ELSE e3 END As you can see, the NVL2() function is more concise and less verbose. In this tutorial, you have learned how to use the Oracle NVL2() function to substitute a null value with different

#### Summary

status measured difficulty not learned 37% [default] 0

No repetitions