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