Re: SQL*Loader Question

On 5 Mar 2002 12:35:15 -0800, botham_ian_at_hotmail.com (Ian Terence Botham) wrote:

>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....

Check the skip= option in your documentation. Better still : check the documentation before posting.

Regards

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Tue Mar 05 2002 - 17:30:56 CST