importing to oracle using sql*loader question

From: mark <mark_at_cybertrails.com>
Date: Tue, 06 Jul 1999 08:19:50 -0700
Message-ID: <37821E96.BDF41CD4@cybertrails.com>

does anyone know where i could find an example of a working control file for sql*loader?

here is what im trying to do.... i have this file... each record is one line
the records have 6 parts
last name, first name, date, the plus sign which needs to be ignored, amount, and employee id #
the record has fixed width columns and the date must be converted to an oracle date field.

ABBATE              ADRIAN               1999-05-28+00000084899734
ABBATE              ADRIAN               1999-06-15+00000084899734
ABBATE              ADRIAN               1999-06-30+00000084899734
ABDALLAH       HANNA ESSA    1999-05-28+00000103500800
ABDALLAH       HANNA ESSA    1999-06-15+00000103500800
ABDALLAH       HANNA ESSA    1999-06-30+00000103500800
AGRAWAL        BAJARANG        1999-05-28+00000084801125

All help is Appreciated!

Thanks
Mark Wagner
new DBA
mark_at_cybertrails.com Received on Tue Jul 06 1999 - 10:19:50 CDT