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.

Tags
#null
Question

### A) Oracle NVL2() function with numeric data type example

The following statement returns two because the first argument is null.

 1 2 3 4 SELECT NVL2 ( NULL , 1, 2) -- 2 FROM dual;

Tags
#null
Question

### A) Oracle NVL2() function with numeric data type example

The following statement returns two because the first argument is null.

?

Tags
#null
Question

### A) Oracle NVL2() function with numeric data type example

The following statement returns two because the first argument is null.

 1 2 3 4 SELECT NVL2 ( NULL , 1, 2) -- 2 FROM dual;
If you want to change selection, open document below and click on "Move attachment"

Oracle NVL2 Function By Practical Examples
he following flowchart illustrates how the Oracle NVL2() function works. Oracle NVL2() function examples Let’s take some examples of using the Oracle NVL2() function to understand how it works. <span>A) Oracle NVL2() function with numeric data type example The following statement returns two because the first argument is null. 1 2 3 4 SELECT NVL2(NULL, 1, 2) -- 2 FROM dual; B) Oracle NVL2() function with character data type example The following example returns the second argument which is the ABC string because the first argument is not null. 1 2 3 4 SELE

#### Summary

status measured difficulty not learned 37% [default] 0

No repetitions

### Discussion

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