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;

explain about mysql and its features. : Sql dba

730

---

What is keys and its types?

743

---

What are string functions in sql?

881

---

Which normal form is best?

671

---

What are actual parameters and formal parameters?

770

---

---

What will you get by the cursor attribute sql%notfound?

777

---

Which is the correct statement about truncate and delete?

753

---

Can we debug stored procedure?

718

---

How do I write a sql query in pgadmin 4?

712

---

What is data control language?

731

---

What are the various levels of constraints?

851

---

Which table is left in join?

683

---

Does pl/sql support create command?

736

---

what are enums used for in mysql? : Sql dba

814

---

How can use stored procedures in sql?

767

---