select substr('DECCANPARK',-5,6) FROM DUAL
Reveal answer
Fill a bubble to check yourself
Keep practicing — related questions
- select substr('DECCANPARK',3,-1) FROM DUAL would results in?
- what is the output: select substr('Oracle Basics',-5,3) from dual
- Identify the correct output --- select SUBSTR('ORACLE BASICS',-6,5) from dual;
- select instr('Hi Partha Sarathi Ojha','a',6,-1) from dual; The output would be..
- SELECT NVL2(null,'second','third') FROM DUAL ;
- SELECT CONCAT(SUBSTR('MINDWORKS',-5,6),SUBSTR('KNOWMAX',-3,4)) FROM DUAL;
- SELECT NVL2('first','second','testing') FROM DUAL ;
- The output of the query " Select length(substr('SQL Functions',-10,12)) from dual; " is