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;

Is sql low level language?

1063

---

What are the different operators available in sql?

1053

---

What is an ndf file?

1058

---

What packages(if any) has oracle provided for use by developers?

5877

---

Why stored procedures are faster than query?

1076

---

How do you delete data from a table?

1092

---

How to rename a table?

1070

---

Which nosql database is best?

1020

---

What is composite data type in pl sql?

1165

---

How do I add a primary key to a table?

1079

---

How do I filter in sql profiler?

1044

---

What is java sql drivermanager?

1157

---

How can you save or place your msg in a table?

1032

---

what is an alias command? : Sql dba

1165

---

Write a sql query to convert all character to uppercase after hypen.

1484

---