What is the result of the following SQL statement? SELECT INDEX (SUBSTRING ('RALPH JOHNSON' FROM 6 FOR 5), 'OHN');
Reveal answer
Fill a bubble to check yourself
Keep practicing — related questions
- What is the output? SELECT SUBSTRING('123456', 0, 3)
- What is the output? SELECT SUBSTRING('123456', 0, 3)
- what is the output: select substr('Oracle Basics',-5,3) from dual
- Which of the following SELECT statements will get the result 'elloworld' from the string 'HelloWorld'?
- select trim(column_name1),left(column_name2,5),substring(column_name3,2,4) from Table1 - The result of the ...
- Which of the following SELECT statements will get the result 'elloworld' from the string 'HelloWorld'?
- Identify the correct output --- select SUBSTR('ORACLE BASICS',-6,5) from dual;
- What will be the output of the following statement? SELECT STR(6365, 3)