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!

Create new rows for each value in a comma separated column

Brendan LeeDec 4 2024

Hi, I'm very inexperienced and looking to print a row for each comma separated value in the SUBGROUPS column. I could do a SQL block for each value and then UNION them all together, but is there a better way? I've attached the data I have as well as the new dataset I am looking to create. Thanks so much.

Example.xlsx

This post has been answered by mathguy on Dec 4 2024
Jump to Answer
Comments
Post Details
Added on Dec 4 2024
9 comments
261 views