Re: SQL*Loader data on different lines
Date: Sat, 20 Jan 2001 10:51:48 -0800
Message-ID: <t6jopj8kgonsa1_at_corp.supernews.com>
"Philippe Makowski" <makowski.philippe_at_wanadoo.fr> wrote in message
news:949lm9$frv$1_at_wanadoo.fr...
> I have to load a file with data on the fisrt line that I have to load each
> time I load data on other line.
> my data look like this :
>
> a1 somedata
> p1 somedata
> p2 somedata
> p1 somedata
>
>
> And I have to load for each row of my table data that are on line a1,p1 and
> p2
>
> Is there a way to do this ?
Not fully understanding your question. Are you saying as you read through the file from top to bottom the 'a1', 'p1', and 'p2' indicate different tables to insert into?
If so, SQL*Loader I believe isn't designed to handle this. Instead, you probably should use PL/SQL and use the UTL_FILE package to read the file and conidtionally insert into your tables while evaluating the incoming data.
SQL*Loader is for the most part a simplistic one-table-at-a-time slam-dunk without much conditional processing. It's great but it's designed mostly for simple one line = one record and one-session = one table situation.
-Matt Received on Sat Jan 20 2001 - 19:51:48 CET