Re: SQL*Loader question

andyho99_at_yahoo.com (Andrew) wrote:

>Hi,
>
>I am trying to load a flat file into Oracle tables using SQL*Loader.
>There are 5 record types in the file. Only record type 1 is mandatory.
>In other word, the file is arranged by a group fashion. Each group may
>contain 1 to 5 records for each record type. Each record type will be
>loaded to corresponding target table. I need to generate sequence
>number for record type 1, and the remaining records in the same group
>should use the sequence number created for the record type 1.
>
>Can I achieve what I want using SQL*LOADER? I couldn't find any
>control file examples that load multiple table and subsequent tables
>using the value from first table. Thanks

You may find it easier to load the data into an interim table and write a Pl/Sql procedure to do the 'distribution' to the other tables...

----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==---- http://www.newsfeed.com The #1 Newsgroup Service in the World! >100,000 Newsgroups ---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption =--- Received on Wed May 14 2003 - 12:05:45 CDT