sqlloader

hi
i need a help on sqloader. i hv .dat file which consist the fields
like as follows

inv.dat
-------

"abc",92,3,"vish,"rad","bad",25

"xyz",92,2,"lath","path",36

"pqr",93,4,"car","van","jeep,"truck",45

depending on the third column the values will be changing and it will be
loading into the oracle table as follows but we are not considering the
third column in the dat file.

name status psn1 psn2 psn3 psn4 psn5 inv
---- ------ ---- ---- ----- ----- ----- -----
abc 92 vish rad bad null null 25
xyz 92 lath path null null null 36
pqr 92 car van jeep truck null 45


Actually the third column in DAT file is not the column of the oracle table .
it indicating the no of values are going to store in the psn1 psn2 ...
let say, the third column is 2 and the data will be loaded in psn1 and psn2
and remaining psn3,psn4 and psn5 shud load as NULLs.

i would appreciate if any body has a solution for the above problem,how
we can load the data (using sqlloader) from DAT file to oracle table the
above dat file to table where the psn1 psn2 values are not fixed.
kindlyprovide me the solution as soon as possible and let me know the
possible ways of the above said problem.


thanks in advance

swetha

Hi swetha

we can do this with the SQL*Loader. But it could be the easy if you would wirte a PRO*C .

If you have any questions, feel free to contact.

Thanks.

Hi swetha

my email id- chandra_2000_us@yahoo.com


[Edited by Chandra on 11-14-2000 at 09:13 AM]

hi Mr.chandra...

thankx for the reply. how can i accomplish the same thing using sqlloader.
if u find time kindly give the solution also with all possible ways


swetha