select substr('DECCANPARK',3,-1) FROM DUAL would results in?
Reveal answer
Fill a bubble to check yourself
Keep practicing — related questions
- select substr('DECCANPARK',-5,6) FROM DUAL
- 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 CONCAT(SUBSTR('MINDWORKS',-5,6),SUBSTR('KNOWMAX',-3,4)) FROM DUAL;
- What is the output of the following? substr (hiredate, - 2, 2) Given that hiredate is 01 Feb 13.
- The output of the query " Select length(substr('SQL Functions',-10,12)) from dual; " is
- Which of the following SELECT statements will get the result 'elloworld' from the string 'HelloWorld'?