Re: SQLLDR field concatenation

You may need to user "positional" loading. i.e. characters 1-3 go into col1, etc...

But number to below would suggest you need to load ccc twice: once into col2 and once into another column. I'm not sure of your intentions.

oracle_man

Richard C Parker wrote in message <889gvq$680$1_at_bw107zhb.bluewin.ch>...
>I have two queries regarding sqlldr:
>
>1. I'm trying to load a CSV file of the form
> aaa,bbb,ccc,ddd
> into a table of 3 columns col1,col2,col3 and want the col1 to be aaa,
>col2 to be bbbccc and col3 to be ddd
>
>2. Same as above only col2 to be bbb (so no column to get ccc)
>
>The sqlldr doco from Oracle is not as helpful as I'd hoped
>
>Thanks for any advice
>Richard Parker
>tntrcparke_at_tsnxt.co.uk
>
>
Received on Tue Feb 15 2000 - 00:00:00 CET