Re: SQL Loader Question on 8.1.7

From: Mike Spalinger <Michael.Spalinger_at_Sun.COM>
Date: Wed, 16 Jun 2004 16:39:44 -0600
Message-id: <40D0CC30.6090104@sun.com>

Kevin,

I think there's an example of this in SQL*Loader Case Study 7 in the 9.2 Utilities Guide. You can use package variables and triggers to save your dept numbers.

Mike

Kevin Lange wrote:
> Evening;
> I figured if anyone would know ... you all would. Here is a simple
> example given in the Oracle SQLLDR manual:
>
> You have conditional data in a singl file to be loaded into different
> tables:
>
> 1 50 Manufacturing
> 2 1100 Smith
> 2 1200 Snyder
> 1 60 Shipping
> 2 1121 Stevens
>

<snip>
>
> It gets more difficult when you ask the question .... Can you carry the
> data from one of the When sections over into another section ?? i.e. Is
> there a way to make a presistant variable that is set in one section and
> then used in another section ??
>
> Using the sample above, we need to have the "Department Number" (depno)
> inserted into the EMP table without having to add it to each individual
> record where recid = 2 since it is already on the record where recid = 1.
>
>
> Any help or direction to go for samples if possible would be greatly
> appreciated.
>
> Kevin

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Wed Jun 16 2004 - 17:37:31 CDT