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 This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is write ahead logging in sql server?
What is the difference between count 1 and count (*) in a sql query?
Lookups are a key component in sql server integration services (ssis). Explain its purpose?
How do I count duplicates in sql?
What is duration in sql profiler trace?
What is sql and also describe types of sql statements?
What is a mutating table and a constraining table?
How to run sql*plus commands in sql developer?
What is count * in sql?
What is the difference between stored procedure and view?
Explain the purpose of %type and %rowtype data types with the example?
How do you delete a table?
What company owns postgresql?
What is a sql driver?
What are different joins used in sql?