Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Reading CLOBs

Re: Reading CLOBs

From: Valentin Minzatu <valentinminzatu_at_yahoo.com>
Date: 26 Oct 2006 06:15:27 -0700
Message-ID: <1161868527.186739.209840@e3g2000cwe.googlegroups.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US