Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Changing alternative letters into upper case

User_F2HJQNov 15 2012 — edited Nov 15 2012
Hi All,

11gR2 DB.

Requirement is to Change alternative letters into upper case starting from the first letter.
(this is some kind of token in our application)

How can we achieve that?

Input - abcdefgh
output - AbCdEfGh

Thanks in advance
This post has been answered by Solomon Yakobson on Nov 15 2012
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 13 2012
Added on Nov 15 2012
24 comments
1,354 views