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
discuss about myisam key cache. : Sql dba
What does where 1 1 mean in sql?
What is an exception in pl/sql?
What is before trigger?
Can we update views in sql?
What is embedded sql in db2?
Write a sql query to find the names of employees that begin with ‘a’?
What is a record in a database?
What can sql server reporting services do?
Can a procedure in a package be overloaded?
explain advantages of innodb over myisam. : Sql dba
What are sql commands?
Can we use ddl statements in stored procedure?
Is left join and outer join same?
What is sqlcontext?
