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!

Parsing CLOB data delimited by new line.

BugsNov 7 2019 — edited Nov 10 2019

Guys,

One of my CLOB column has data as below:

"BSC01

BSC02

BSC03

BSC04

BSC05

BSC06"

Could someone please suggest a way to parse it to 7 records. They will subsequently be inserted into another table as 7 records.

Thank you!

This post has been answered by Solomon Yakobson on Nov 7 2019
Jump to Answer
Comments
Post Details
Added on Nov 7 2019
6 comments
5,095 views