Re: alternatives to sql*loader
From: (wrong string) é Klück <akluck01_at_wxs.nl>
Date: 2000/08/05
Message-ID: <398BF944.102887CA_at_wxs.nl>#1/1
Date: 2000/08/05
Message-ID: <398BF944.102887CA_at_wxs.nl>#1/1
Use SQL*Loader to get all strings into a table, labelled with your own
primary key.
So, your records are filled by varchar2(2000) or varchar2(4000).
Later you can do what ever you have to do from this table to any other tables by using PL/SQL (or Pro*C if very complicated).
SQL*Loader has some real good advantages. The disadvantage you can overcome by inserting into a "stage"-table.
Christopher Freville wrote:
> are there any alternatives to sql*loader ?
> it is somewhat frustrating to use when you've got a complex, unstructured
> data file
>
> please help
> Chris Freville
Received on Sat Aug 05 2000 - 00:00:00 CEST