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 bulk bind

4 Answers   TCS,

---

Define concurrency control. : Transact sql

0 Answers  

---

What is the difference between having clause and where clause?

0 Answers  

---

what is the difference between implicit conversions and explicit conversions?

2 Answers  

---

What is the main difference between a UNION statement and a UNION ALL statement? 1. A UNION statement eliminates duplicate rows; a UNION ALL statement includes duplicate rows. 2. A UNION statement can be used to combine any number of queries; a UNION ALL statement can be used to combine a maximum of two queries. 3. A UNION statement can only combine queries that have parallel fields in the SELECT list; a UNION ALL statement can combine queries with differing SELECT list structures. 4. A UNION statement cannot be used with aggregate functions; a UNION ALL statement can be used with aggregate functions. 5. There is no difference between the two statements; they are interchangeable.

2 Answers   Saman Bank, Sonata,

---

What is sql exception?

0 Answers  

---

Can we commit in trigger?

0 Answers  

---

What are actual parameters and formal parameters?

0 Answers  

---

What does t sql mean?

0 Answers  

---

what is inline command?

2 Answers  

---

Can we use two order by clause in query?

0 Answers  

---

What is sql architecture?

0 Answers  

---