1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

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

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 to select all records from the table?

601

What are pl/sql cursors?

561

Explain two easy sql optimizations.

602

Mention what is the function that is used to transfer a pl/sql table log to a database table?

483

What do you mean by field in sql?

530




What is sql injection owasp?

546

What is trigger price?

537

What are the disadvantages of file system?

614

Difference between truncate, delete and drop commands?

554

What is a .db file?

534

explain access control lists. : Sql dba

553

What is a natural join?

511

What is sql stand for?

571

What are some emotional triggers?

568

How much does sqlite cost?

551