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 trigger in sql?

0 Answers  

---

What is partition by in sql?

0 Answers  

---

what does the t-sql command ident_current does? : Transact sql

0 Answers  

---

What are the query optimization techniques?

0 Answers  

---

What has stored procedures in sql?

0 Answers  

---

What is the sql*loader? : aql loader

0 Answers  

---

Enlist the data types that can be used in pl/sql?

0 Answers  

---

I have a tablle like this: cust acc ----------- a 1 b 2 b 3 c 4 c 5 c 6 I Want below o/p: cust acc --------------- a 1 b 2|3 c 4|5|6 Please any one can you have any ideas share me. I have urgent requirement.

7 Answers   MTS,

---

What is the benefit of foreign key?

0 Answers  

---

How many primary keys can a table have?

0 Answers  

---

explain what is mysql? : Sql dba

0 Answers  

---

How can u find column name from a table which have max value in a row.( not max value)

5 Answers  

---