Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Help- importing data to oracle database

Help- importing data to oracle database

From: Johnson Zhao <zhao_at_apas.co.jp>
Date: Fri, 10 Mar 2000 09:54:50 +0900
Message-ID: <8a9h05$23m$1@nn-tk105.ocn.ad.jp>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US