Re: Convert CSV data held in a CLOB into columns

In article <1197243180.661199_at_bubbleator.drizzle.com>, DA Morgan says...
> > Re-read the original post and you will see what I am trying to achieve.
> > A CLOB's content may have structure - e.g. XML - I am trying to
> > determine if there is a method by which the content of a CLOB, when
> > known to be in CSV format, can be easily procesed in pl/sql.
>
> Clearly the answer is yes. You can efficiently use DBMS_LOB.SUBSTR and
> DBMS_LOB.INSTR to parse it up rather efficiently.

So it would appear there is no "packaged" method for this - a roll-your- own approach seems to be the order of the day.

>
> What you then do with the pieces is up to you.
>

Quite.

-- 
jeremy