BuboFlash - helps with learning

Do you want BuboFlash to help you learning these things? Or do you want to add or correct something? Click here to log in or create user.

Presentation
Question

Answer

Tags

#null

Question

Oracle NVL2() function and CASE expression

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

Answer

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	not learned	measured difficulty	37% [default]	last interval [days]
repetition number in this series	0	memorised on		scheduled repetition
scheduled repetition interval		last repetition or drill

Details

No repetitions

Discussion

Do you want to join discussion? Click here to log in or create user.