Multiple choice

Which of the following SELECT statements will get the result 'elloworld' from the string 'HelloWorld'?

  1. SELECT SUBSTR('HelloWorld',1) FROM dual;

  2. SELECT INITCAP(TRIM('HelloWorld', 1,1) FROM dual;

  3. SELECT LOWER(SUBSTR ('HelloWorld', 2,1) FROM dual;

  4. SELECT LOWER(SUBSTR('HelloWorld', 2,1) FROM dual;

  5. SELECT LOWER(TRIM ('H' FROM 'Hello World')) FROM dual;
Reveal answer Fill a bubble to check yourself
E Correct answer

Keep practicing — related questions