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 to get a list of all tables in a database? : Sql dba
What is before and after trigger?
What does partition by mean in sql?
Does user triggers have entry for trigger with compilation errors?
What are all the different normalizations?
What is a temp table?
What is relationship? How many types of relationship are there?
How do you rename a table in sql?
How many developers work on postgresql?
How to use sql*plus built-in timers?
How can the performance of a trigger be improved?
Do prepared statements prevent sql injection?
What version is sql?
Why is a primary key important?
define sql update statement ? : Sql dba