Register Login

Which SELECT statement will get the result 'elloworld' fromt the string 'HelloWorld'?

Updated Jun 07, 2019

Q. Which SELECT statement will get the result 'elloworld' fromt the string 'HelloWorld'?

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

B. SELECT INITCAP(TRIM('HellowWorld', 1,1) FROM dual

C. SELECT LOWER (SUBSTR ('HellowWorld', 2,1) FROM dual

D. SELECT LOWER (SUBSTR('HellowWorld', 2,1) FROM dual

E. SELECT LOWER (TRIM ('H' FROM 'Hello World')) FROM dual

Answer: E

E. SELECT LOWER (TRIM ('H' FROM 'Hello World')) FROM dual


×