Question: how does nvl2 work in oracle?
Answer: Oracle NVL2() overview The Oracle NVL2() function accepts three arguments. If the first argument is not null, then it returns the second argument. In case the second argument is null, then it returns the third argument. In this syntax, the first argument e1 can be a value of any data type.