how to nvl in oracle?
Introduction to Oracle NVL() function The NVL() function accepts two arguments. If e1 evaluates to null, then NVL() function returns e2 . If e1 evaluates to non-null, the NVL() function returns e1 . The two arguments e1 and e2 can have the same or different data types.