Tags
#null
Question

### 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 SELECT NVL2 (1, 'ABC' , 'XYZ' ) FROM dual;

Tags
#null
Question

### 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.

?

Tags
#null
Question

### 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 SELECT NVL2 (1, 'ABC' , 'XYZ' ) FROM dual;
If you want to change selection, open document below and click on "Move attachment"

Oracle NVL2 Function By Practical Examples
nd how it works. 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; <span>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 SELECT NVL2(1, 'ABC', 'XYZ') FROM dual; C) Oracle NVL2() function with orders example See the following employees and orders tables from the sample database : The following query retrieves order id, order date, and the name o

#### Summary

status measured difficulty not learned 37% [default] 0

No repetitions