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

What is the least restrictive isolation level? : Transact sql

998

Where do we use pl sql?

945

How do I run a pl sql procedure in sql developer?

916

What is a recursive join sql?

1027

Is it possible to create startup or shutdown trigger for on-schema?

981

Explain how exception handling is done in advance pl/sql?

958

Is not null in sql?

932

What is query optimization in sql?

941

What is %type in sql?

920

What is the use of sqlerrd 3?

890

Write the command to remove all players named sachin from the players table.

1124

How do you truncate?

855

What are the different ways to optimize a sql query?

891

Explain what is a subquery ?

1125

What is delimiter in pl sql?

992