Answer Posted / raveendran
In Oracle/PLSQL, the NVL function lets you substitute a
value when a null value is encountered.
The syntax for the NVL function is:
NVL( string1, replace_with )
string1 is the string to test for a null value.
replace_with is the value returned if string1 is null.
| Is This Answer Correct ? | 20 Yes | 2 No |
Post New Answer View All Answers
How do I order columns in sql?
How to call a javascript function from pl sql?
How can I speed up sql query?
Explain how exception handling is done in advance pl/sql?
Is primary key an index?
what is difference between delete and truncate commands? : Sql dba
Can there be more than one function with a similar name in a pl/sql block?
What is a full join?
How does cross join work in sql?
What do we need to check in database testing?
What are the types of keys?
Explain what is an index?
Can you join views in sql?
What is %type in pl sql?
Why do we need cursor in pl sql?