| sqlloader [message #368328] |
Mon, 13 November 2000 20:05 |
swetha
Messages: 10
Registered: November 2000
|
Junior Member |
|
|
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
