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!

Split field into separate values

User_VKU4XSep 6 2019 — edited Sep 9 2019

Hi

I want to split a string separated by a comma or space into separate values.

eg. John, Miller C. should be split into separate fields - John, Miller, C.

Please let me know the solution using regular expression.

Thanks!

Comments
Post Details
Added on Sep 6 2019
7 comments
3,404 views