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 scalar and vector?

0 Answers  

---

i have a table with column sno with 30 records. i want to update this column by item by item in asp.net. i wantto enter new values into that from 1 to 30 how is it possible with backend c#

1 Answers  

---

Can you rollback after commit?

0 Answers  

---

What is mutating table error?

0 Answers  

---

What sql database should I use?

0 Answers  

---

Explain the difference between triggers and constraints?

0 Answers  

---

What is a mutating table and a constraining table?

0 Answers  

---

How to handle bulk data?

0 Answers  

---

How many scalar data types are supported in pl/sql?

0 Answers  

---

what are the advantages of package?

7 Answers   iFlex,

---

Why do we use procedures in sql?

0 Answers  

---

If you have to declare procedure1,procedure2 in package specification and if you have to declare procedure1,procedure2 and procedure3 in package body? is it compilation or not and execute or not? what type of error is given please

1 Answers  

---