Question:Which of the following SELECT statements will get the result 'elloworld' from 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 (TRIM ('H' FROM 'HelloWorld')) FROM dual; 

+ Answer
+ Report
Total Preview: 1070

Copyright © 2024. Powered by Intellect Software Ltd