Re: alternatives to sql*loader

From: <yitbsal_at_statcan.ca>
Date: 2000/08/04
Message-ID: <8mf207$4pp$1@nnrp1.deja.com>#1/1

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