Re: alternatives to sql*loader

The "ultimate alternative" (so to speak) is Perl. Unless there's no regularity at all, you can always write a Perl program to efficiently parse very complicated strings in your data file.

Yong Huang
yhuang_at_indigopool.com

<yitbsal_at_statcan.ca> wrote in message news:8mf207$4pp$1_at_nnrp1.deja.com...
> In article <lzBi5.4401$PA2.39550_at_monolith.news.easynet.net>,
> "Christopher Freville" <cfreville_at_eidosnet.co.uk> wrote:
> > are there any alternatives to sql*loader ?
> > it is somewhat frustrating to use when you've got a complex,
 unstructured
> > data file
> >
>
> In these cases, we usually end up using PL/SQL and the UTL_FILE package
> to read the contents of the file and insert into tables. Of course,
> this is a bit slower than SQL Loader, but simpler and easier to use
> with complex files.
>
> Salaam Yitbarek
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Fri Aug 04 2000 - 00:00:00 CDT