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 the plv (pl/vision) package offers?
What is trigger in sql and its types?
what is csv? : Sql dba
Explain the update statement in sql
What is a memo field?
What is procedure explain with program?
How to order siblings in oracle hierarchy queries?
what is an alias command? : Sql dba
how can we encrypt and decrypt a data present in a mysql table using mysql? : Sql dba
Which type of cursor is used to execute the dml statement?
Which column in the user.triggers data dictionary view shows that the trigger is a pl/sql trigger?
How to download oracle sql developer?
Does pl/sql support create command?
Why we use join in sql?
What schema means?