Answer / sushma s

NVL function substitute a value when a null value is
encountered.
NVL2: substitutes a value when a null value is encountered
as well as when a non-null value is encountered.

The syntax for the NVL2 function is:

NVL2( string1, value_if_NOT_null, value_if_null )

string1 is the string to test for a null value.

value_if_NOT_null is the value returned if string1 is not null.

value_if_null is the value returned if string1 is null.

NULLIF: NULLIF function compares expr1 and expr2. If expr1
and expr2 are equal, the NULLIF function returns NULL.
Otherwise, it returns expr1.

What is the use of sqlerrd 3?

0 Answers  

---

table - new_no old_no 2345 1234 3456 2345 5678 4567 output sud be -new_no 1234 2345 3456 4567 5678

2 Answers  

---

What is an escape character in sql?

0 Answers  

---

How can we avoid duplicating records in a query?

0 Answers  

---

When is a declare statement required?

0 Answers  

---

What are all the different types of indexes?

0 Answers  

---

What is difference between pl and sql?

0 Answers  

---

What does trigger mean in psychology?

0 Answers  

---

What is assignment operator in pl sql?

0 Answers  

---

how to retrieve the top 2 salaried persons from a database?

7 Answers   Orion Laboratories,

---

Give the structure of the procedure ?

1 Answers  

---

what will be the output: select 1 from emp union all select 2 from emp;

2 Answers   iNautix,

---