Tag: databases

select version from dual ;

Output of the below two queries will be same.. 1.select nvl('abc','a') from dual; 2.select nvl('abc',0) from dual;

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

select instr('Hi Partha Sarathi Ojha','a',6,-1) from dual; The output would be..

select instr('Hi Partha Sarathi Ojha','a',5) from dual; The o/p would be...

select translate('abcda','ab','ef') from dual; The o/p would be...

select replace('abcda','ab','ef') from dual ; The o/p would be..

The o/p of the below two queries will be same ? 1.select translate('abcd','a','d') from dual; 2.select replace('abcd','a','d') from dual;