Answer Posted / Pradeep Dwivedi
NVL is a built-in Oracle function that replaces NULL values with specified replacement values. It takes two arguments: the first is the expression that may return a NULL value, and the second is the replacement value. For example, NVL(column_name, default_value) would replace any NULL values in column_name with default_value.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Design database draw er diagram for a certain scenario ?
How to put more than 1000 values into an oracle in clause?
What is oracle latest version?
Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com
How to use values from other tables in update statements using oracle?
How to write a left outer join with the where clause in oracle?
How to start an oracle instance?
How to select all columns of all rows from a table in oracle?
