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
What are sql procedures?
How do you explain an index?
Is oracle sql free?
What are the different types of triggers?
What is the difference between partition and index?
Is there a 64 bit version of ssms?
Can we use insert statement in function?
How much does a sql dba make? : SQL DBA
What language is oracle sql developer?
how to create a new table by selecting rows from another table in mysql? : Sql dba
Is a view faster than a stored procedure?
What is the default isolation level in sql server? : Transact sql
What is pl sql collection?
What is difference between mysql and postgresql?
Why use truncate instead of delete?