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!

i want to put comman inside the string

ibneyJun 10 2014 — edited Jun 18 2014

i have this string '1077 Meadow LNNeenah, WI 54956'  . before  the comma word  i have to put , if first Caps character is capital

'1077 Meadow LNNeenah, WI 54956' this string

                           before comma       word is LNNeenah this part have to split if last character is Caps then put comma  like LN,Neenah  

i want print above string as '1077 Meadow LN,Neenah, WI 54956'

Please some help me on this i have urgent requirement

This post has been answered by chris227 on Jun 18 2014
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 16 2014
Added on Jun 10 2014
13 comments
4,482 views