You can find in
1. ORAcle Utilities handbook
2. $ORACLE_HOME/rdbms/demo/*.ctl , *.sql files
-Thiru
mark <mark_at_cybertrails.com> wrote in message
news:37821E96.BDF41CD4_at_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 - 11:14:22 CDT
