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
Can you sum a count in sql?
Can we use join in subquery?
how to create a test table in your mysql server? : Sql dba
What is materialized view. What are different methods of refresh?
What is sqlcontext?
What is the use of index in sql?
Can a foreign key be a duplicate?
What is raid? How does it help storage of databases?
What is a natural join?
What is a constraint?
How do I make sql search faster?
What is a variable in sql?
Can dml statements be used in pl/sql?
What are the conditions an underlying table must satisfy before a cursor can be used by a positioned update or delete statement? : Transact sql
What are the possible values that can be stored in a boolean data field?