What is returned from the query SELECT NVL2(NULL,'V1','V2') from DUAL;
Reveal answer
Fill a bubble to check yourself
Keep practicing — related questions
- select nvl2(exp1,exp2,exp3) from dual. In this if exp1 is null,what will be the output?
- SELECT NVL2(null,'second','third') FROM DUAL ;
- What output will the follwing statement produce? Select NVL2(NULL,'NOT NULL', NULL) from dual?
- What output will the follwing statement produce? Select NVL2(NULL,NOT NULL, NULL) from dual?
- What output will the follwing statement produce? Select NVL2(NULL,'NOT NULL', NULL) from dual;
- What output will the follwing statement produce? Select NVL2(NULL,'NOT NULL', NULL) from dual;
- What output will the follwing statement produce? Select NVL2(NULL,'NOT NULL', NULL) from dual;
- What output will the given statement produce? Select NVL2(NULL,'NOT NULL', NULL) from dual;