Output of the below two queries will be same.. 1.select nvl('abc','a') from dual; 2.select nvl('abc',0) from dual;
Reveal answer
Fill a bubble to check yourself
Keep practicing — related questions
- Output of the below two queries would be same.. 1.select 1 from dual; 2.select '1' from dual;
- The o/p of the below two queries would be same.. 1.select '1'+1 from dual; 2.select 1+1 from dual;
- What is returned from the query SELECT NVL2(NULL,'V1','V2') from DUAL;
- select nvl2(exp1,exp2,exp3) from dual. In this if exp1 is null,what will be the output?
- SELECT NVL(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;
- What output will the follwing statement produce? Select NVL2(NULL,'NOT NULL', NULL) from dual;