Answer Posted / gayathri
NVL function is used to replace the null value by another
value
The syntax for the NVL function is:
NVL( value_in, replace_with )
replace_with is the value that is returned if value_in has
a null value.
| Is This Answer Correct ? | 17 Yes | 0 No |
Post New Answer View All Answers
How can you save or place your msg in a table?
Why is a primary key important?
What is the maximum number of columns in sql table?
Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me
Why are aggregate functions called so?
How show all rows in sql?
When are we going to use truncate and delete?
What is equi join in sql?
What is sqlca in db2?
when MSQL8.0 is in market
what is commit? : Sql dba
What is the use of function in sql?
Can we use insert statement in function?
What is sql*loader and what is it used for?
Does sql profiler affect performance?