Splitting a clob into rows

My blog has moved, the article you are looking for can be found here:


About Sean D. Stuber
Developer, DBA, Oracle ACE

7 Responses to Splitting a clob into rows

  1. Claudio says:

    No other comments here? Really? This solution seems to be the fastest clob splitter by far – if you are parsing large clobs you must try this.

    Thanks Sean!


  2. Darpic says:

    I have found many functions of this type. This is the only one that works and does not alter the data.

    Liked by 1 person

  3. Glenn says:

    Thanks Sean, excellent piece of code

    Liked by 1 person

  4. Pingback: How to pass a vector or data.frame from R to Oracle as a bind variable in a select statement using ROracle. | seanstuber

  5. Moritz Koeppen says:

    Thanks Sean! Excellent piece of code! Great work! I was using a function which was using REGEXP_LIKE and was running for 5 hours on some table. This code reduced the time to 0,4 seconds!


Questions and Comments always welcome

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: