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
Is ms sql is free?
define sql update statement ? : Sql dba
Where are my tempfiles, I don't see them in v$datafile or dba_data_file?
What is the difference between distinct and unique in sql?
mention if it is possible to import data directly from t-sql commands without using sql server integration services? If yes, what are the commands? : Transact sql
How to read/write files from pl/sql?
What are the most important ddl statements in sql?
how would you get the current date in mysql? : Sql dba
What is coalesce sql?
What is the default isolation level in sql server? : Transact sql
how can we know the count/number of elements of an array? : Sql dba
What is the starting oracle error number? What is meant by forward declaration in functions?
What are the different sql commands?
What does cursor do in sql?
What are sql ddl commands?