Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Reading CLOBs
BTW when I said arrays I was also alluding to bulk processing.
Valentin Minzatu wrote:
> >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:15:27 CDT