Pre Exam Test Practice (SSC | Banking | IAS | GATE | State Level | CLAT | Railways | Insurance | Teaching Exams | NDA | Defence | IES |State Exam )

Organizational Research By

Surprising Reserch Topic

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 (SUBSTR('HellowWorld', 2,1) FROM dual;
e.        SELECT LOWER (TRIM ('H' FROM 'Hello World')) FROM dual;

asked Sep 13, 2013 in MYSQL by anonymous
edited Sep 12, 2013
0 votes

Related Hot Questions

Government Jobs Opening