Re: reg : SQL LOADER

From: Afshin Ghafoori <ash_at_lantis.demon.co.uk>
Date: 1996/06/24
Message-ID: <835655606.16442.0_at_lantis.demon.co.uk>#1/1


M Rajeshwar <MR1154_at_CAMBER.COM> wrote:

>How am i to load only selected columns from a flat file onto an oracle
>table using sql loader ? I have found that it does not have a
>provision to do this. Then how am I going over this problem ?

You could do this in two stages:
1) Load into a temporary table;
2) Load the target table as a select from the temporary.

How does this sound? Received on Mon Jun 24 1996 - 00:00:00 CEST

Original text of this message