Re: SQL*Loader Question

add the line
OPTIONS ( SKIP=2) on the head of your controlfile.

Mourad:)

"Ian Terence Botham" <botham_ian_at_hotmail.com> a écrit dans le message news: 709f185b.0203051235.5aab5c23_at_posting.google.com...
> I just managed to write a script(in perl) that would pull the data
> displayed on the webite into a datafile. The datafile looks like this
>
> Client_id XYZCompany
> base,quote,amount,date,ask,bid
> USD,,1,03-01-2002,1.1565,1.1558
> USD,CAD,1,03-01-2002,1.5930,1.5922
> USD,JPY,1,03-01-2002,133.360,133.300
> USD,MXP,1,03-01-2002,9.1136,9.0636
> USD,CHF,1,03-01-2002,1.7083,1.7073
> USD,GBP,1,03-01-2002,0.7051,0.7047
> USD,EUR,1,03-01-2002,1.1565,1.1558
> USD,AUD,1,03-01-2002,1.9253,1.9242
> USD,HKD,1,03-01-2002,7.8004,7.7992
> USD,SGD,1,03-01-2002,1.8329,1.8321
> USD,TWD,1,03-01-2002,35.1005,35.1005
> USD,INR,1,03-01-2002,48.8240,48.6460
> USD,MYR,1,03-01-2002,3.8021,3.7975
> USD,CNY,1,03-01-2002,8.2866,8.2666
> USD,KRW,1,03-01-2002,1324.20,1313.50
> USD,SEK,1,03-01-2002,10.5090,10.5030
>
> I would like to chop off the first 2 lines in the file and load the
> rest into the database....
> Client_id XYZCompany
> base,quote,amount,date,ask,bid
>
> Is it possible thru SQL*Loader to do so?? I would like to get a
> feedback based on which I shall create a script...
>
> Thanks
> Ian....
Received on Wed Mar 06 2002 - 16:12:19 CST