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.

Can a procedure in a package be overloaded?

0 Answers   EXL,

---

Can we use ddl statements in stored procedure sql server?

0 Answers  

---

HOW TO PRINT * ** *** **** ***** BY USING SQL QUERY? (MAY BE USING SCRIPT)

8 Answers   BeBo Technologies,

---

what is the difference between union and union all

14 Answers   IBM, Luxoft, Oracle,

---

what are numeric data types? : Sql dba

0 Answers  

---

How exception handling is done in advance pl/sql?

0 Answers  

---

What are few of the schema objects that are created using PL/SQL?

0 Answers  

---

Explain two virtual tables available at the time of database trigger execution.

1 Answers  

---

Is pl sql different from sql?

0 Answers  

---

What is sql in oracle?

0 Answers  

---

What is the usage of the distinct keyword?

0 Answers  

---

What is a join query?

0 Answers  

---