SQL*Loader for loading multiple records

From: <jairamk_at_geocities.com>
Date: Wed, 23 Jun 1999 19:43:03 GMT
Message-ID: <7krdc4$ge4$1@nnrp1.deja.com>

Hi! Everyone!

I have to load to a flatfile with the following format <Header Fields> <Repeating group>....... ie
col1|col2|col3|col4|col5_1|col5_2|...|col5_n|col6_1|col6_2|...|col6_n

into a table of having the format

(col1,col2,col3,col4,col5,col6)

so essentially one physical record in the file will translate into n logical database records... the problem is how do i specify field positions in the control file... The examples show how to do it to fixed length format files but not with delimited files... i am at my wits end with this...
any help will be great...
thanx in advance
jairam

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Wed Jun 23 1999 - 14:43:03 CDT