Re: Can SQL *Loader parse data from a CLOB source rather than a file?

> I need to parse multiple files that are present on the database within
> CLOBs.
>
> I would like to parse them using SQL Loader, because I believe that it
> would be more efficient in loading the data.
>
> Is there a way to use the CLOB field as a source, rather than a file
> instance?

SQL*Loader is a utility that will read datafiles, not data from within the database. SQL*Loader's job is to put data into the database. Since the data is already in the database, in a CLOB column, why not use straight SQL statements to parse your data? What is it that you think SQL*Loader can do that SQL (and/or PL/SQL) can't do?

Cheers,
Brian

-- 
===================================================================

Brian Peasland
dba_at_remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
 the three"