Mark, there are some examples located in $ORACLE_HOME/rdbms/demo
direcotry.
Ted Chyn
In article <37821E96.BDF41CD4_at_cybertrails.com>,
mark <mark_at_cybertrails.com> wrote:
> 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
>
>
Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't.
Received on Tue Jul 06 1999 - 12:28:11 CDT
