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:
<snip>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
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@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------
