Monday, 27 August 2012

Which SELECT statement will get the result 'elloworld' from the string 'HelloWorld'? | Oracle

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

Ans:E

No comments: