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!

mixed case (alternate upper & lower)...

mariasJun 13 2007 — edited Jun 13 2007

Hello Friends,

1) always 1st character is lowercase,2nd character is uppercase and so on.
2) ignore the spaces/numbers while converting i.e. alternate lower and upper case character

input:
hello world
Good Morning
All Are Fine Here

output:
hElLo WoRlD
gOoD mOrNiNg
aLl ArE fInE hErE

Any help will be appreciated.

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 11 2007

Added on Jun 13 2007

7 comments

600 views