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
What is count * in sql?
What is a record in pl/sql?
what is 'trigger' in sql? : Sql dba
what are the difference between clustered and a non-clustered index? : Sql dba
Why do we need databases?
Does inner join remove duplicates?
How do you modify a table in sql?
Is record in pl sql?
What's the difference between a primary key and a clustered index?
Can we group by two columns in sql?
How delete all data from table in sql?
Which are sql * plus commands?
What is dml and ddl?
how can you see all indexes defined for a table? : Sql dba
What are different types of tables in sql?