Re: Reading CLOBs

>From a bird's eye view point, you could read, parse and write using PL/SQL. You could optimize the processing using arrays if the table is big for performance reasons as well.

I am not very sure what makes the task different than anything else you could do in PL/SQL.

Am I missing the question?

Cheers,
Valentin

artmt_at_hotmail.com wrote:
> I have a CLOB column containing delimited data file.
> I need to parse this data and load it into a regular table.
> The line size is variable.
> The entire operation has to be within the database, I cannot talk to
> the file system.
> Is there a way to do this?
>
> Running v 10.1.0.4.0
>
> Thanks
> Art
Received on Thu Oct 26 2006 - 08:14:08 CDT