Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Help- importing data to oracle database
Hello:
I have a large big data file which include at most 10 columns and at least 6 columns. I have to import all the data to oracle database. In the data file, the first column's data has specific meaning. I have to analyse the first column to judge the later data's meaning and import the data to the relative oracle table. Next below is a snippet I abstracted from the data file.
What is the best way to do this.
Thx in advance
Johnson Zhao from Tokyo
101 105 0 46 487696.828 124500.014 6.000 102 105 0 46 487697.075 124500.538 6.000 101 105 0 46 487695.178 124500.014 8.000 102 105 0 46 487695.398 124500.461 8.000 101 105 0 46 487696.090 124500.014 4.000 62 410 0 43 487661.036 124605.642 62 410 0 43 487660.896 124605.645 62 410 0 43 487660.810 124605.532 61 451 0 70 487795.858 124568.167 62 451 0 70 487795.936 124568.401
-- Received on Thu Mar 09 2000 - 18:54:50 CST