Select 'AbcdEfG',LOWER(SUBSTR('AbcdEfG',1,1))||UPPER(SU

How to convert lowercase letters to uppercase and uppercase letters to lowercase in a string. (ex, AbcdEfG should convert as aBCDeFg)

Question Posted / debashis mohanty

3 Answers
6994 Views
TCS, I also Faced
E-Mail Answers

Answer Posted / debashis mohanty

Select 'AbcdEfG',LOWER(SUBSTR('AbcdEfG',1,1))||UPPER(SUBSTR('AbcdEfG',2,3))||LOWER(SUBSTR('AbcdEfG',5,1))||UPPER(SUBSTR('AbcdEfG',6,1))||LOWER(SUBSTR('AbcdEfG',7,1)) From Dual

Is This Answer Correct ?

0 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How do you update sql?

991

what is a field in a database ? : Sql dba

1067

Can a foreign key have a different name?

943

How does left join work in sql?

1008

What is trigger in sql and its types?

1068

Can dml statements be used in pl/sql?

1087

What is a recursive join sql?

1077

What is loop in pl sql?

1040

How to get help at the sql prompt?

1121

Is truncate ddl or dml?

997

Is sql open source?

979

What is t sql in sql server?

1078

How do I add a primary key to a table?

1044

Explain about various levels of constraint.

949

Why indexing is needed?

993