Online Tutorials & Training Materials | STechies.com
Register Login

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

Shalesh Singh Visen || 05 Mar 2008 5:02 pm || 0

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