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 i use dbms_output.put_line in a function u are telling as return statement

7 Answers  

---

What are the return values of functions SQLCODE and SQLERRM ?

2 Answers   PreVator,

---

What are types of exception?

0 Answers  

---

What is an oracle stored procedure?

0 Answers  

---

What information is needed to connect sql*plus an oracle server?

0 Answers  

---

I need to write a simple query,which one is better select statement or stored procedure?and why?

2 Answers   iGate,

---

Explain the steps needed to create the scheduled job?

0 Answers  

---

Which sql statement is used to delete data from a database?

0 Answers  

---

How to get the procedure's, function's name from a package if it is wrapped(both spec & body).

2 Answers  

---

What normalization means?

0 Answers  

---

The select into statement is most often used to create backup copies of tables or for archiving records?

0 Answers  

---

Explain the structure of pl/sql in brief.

0 Answers  

---