Skip to Main Content

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!

sql query to transform string based on special characters

user12114715Nov 12 2020

i have i/p string ,if there is no special character at the start of each word then all words are made as initcap.
if there is a special character at the start of each word then that word is converted into lower case.
how to do this
image.png

Comments
Post Details
Added on Nov 12 2020
8 comments
1,069 views