What is a nvl function? How can it be used?
- 1 Answers
- 1136 Views
- I also Faced
- E-Mail Answers
Answer / 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 |
query to find the maximum no persons with same age(age colomn) from emp table
What different of iner joint & outer joint with example
What happens if you set the sga too low in oracle?
What is a read write transaction in oracle?
Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size ?
How to select all columns of all rows from a table in oracle?
what are Triggers?
what are pseudocolumns?
Why do I get java.lang.abstractmethoderror when trying to load a blob in the db?
What is difference between SUBSTR and INSTR?
How to export data with a field delimiter?
How to find the date and time of last updated table?
Oracle General 
