Answer Posted / shivaindu

In Oracle/PLSQL, the NVL function lets you substitute a
value when a null value is encountered.

The syntax for the NVL function
-------------------------------

NVL( string1, replace_with )

Example #1:
----------

select NVL(supplier_city, 'n/a' or ‘0’)
from suppliers;

what is the difference between where clause and having clause? : Sql dba

996

---

what's the difference between a primary key and a unique key? : Sql dba

1042

---

What are the types of optimization?

954

---

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

1065

---

How to create your own reports in sql developer?

1017

---

What is the purpose of a secondary key?

964

---

What are actual parameters and formal parameters?

1101

---

What are the different datatypes available in PL/SQL?

1083

---

What is primary key sql?

1032

---

What is record type in pl sql?

984

---

Can we use view in stored procedure?

896

---

Can we join same table in sql?

1016

---

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

1062

---

What is rtm stands for?

1093

---

When to use inner join and left join?

952

---