What output will the follwing statement produce? Select NVL2(NULL,NOT NULL, NULL) 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?
- What is returned from the query SELECT NVL2(NULL,'V1','V2') from DUAL;
- SELECT NVL2(null,'second','third') FROM DUAL ;
- SELECT NVL(null,'testing') FROM DUAL ;
- SELECT NVL2('first','second','testing') FROM DUAL ;
- What is the output of the the query: select 'Sql' from dual where null is null;
- what is the output of the the query: select 'Sql' from dual where null = null;
- What is the impact if DSS database goes down