What is NVL function?
Are you preparing for IT certification? With practice questions, study notes, interactive quizzes, tips and technical articles, uCertify PrepKits ensure that you get a solid grasp of core technical concepts to ace your certification exam in first attempt.
What is NVL function?
Rating:
The NVL function is used when a non-NULL value needs to be returned in place of a NULL value.
The NVL function takes two arguments, p1 and p2. It returns p2 if p1 is NULL. If p1 is not NULL, the function returns p1 itself.
Rating:
Was this information helpful?
Other articles
- What is TO_CHAR (number) function?
- What is object privilege?
- What is TRUNCATE statement?
- What is GROUP BY clause?
- What is schema?