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
6940 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

Explain the insert into statements in sql?

983

Can two tables have same primary key?

954

Does truncate require commit?

955

What is sqlexception in java?

967

What are the two virtual tables available at the time of database trigger execution?

1198

Explain the difference between sql and mysql.

1042

What is the limitation on the block size of pl/sql?

975

What is the current version of postgresql?

1048

what is the command line end user interface - mysql? : Sql dba

967

What is delimiter sql?

966

What are sql injection vulnerabilities?

965

What is difference between db2 and sql?

982

What is difference between pl and sql?

1035

What is the order of sql select?

1030

how can you see all indexes defined for a table? : Sql dba

976