Q
What does NVL2(expr, a, b) return?
-
A
a if expr is NULL, otherwise b
-
B
a if expr is NOT NULL, otherwise b
-
C
Always a
-
D
Always b
Correct Answer:
B. a if expr is NOT NULL, otherwise b
Explanation:
NVL2 tests expr: not null gives the second argument, null gives the third.
