The o/p of the below query would be.. select nvl('abc','a') from dual union all select nvl('abc',0) from dual minus select replace('abc','a','a') from dual
Reveal answer
Fill a bubble to check yourself
Keep practicing — related questions
- Output of the below two queries will be same.. 1.select nvl('abc','a') from dual; 2.select nvl('abc',0) fro...
- SELECT NVL2(null,'second','third') 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 NVL2('first','second','testing') FROM DUAL ;
- The o/p of the below two queries will be same ? 1.select translate('abcd','a','d') from dual; 2.select repl...
- What will be the output of- "Select 1 from dual UNION Select 'A' from dual"
- O/p of the below query ?? select 'a''a' from dual;