3 Replies Latest reply: Nov 14, 2012 3:46 AM by 971895 RSS

    text file to oracle 10g table

      Hi , i have one .txt file generated from xsteel as output containing details of geometry as below , i want to export this information into table.

      the information in text file is like
        1133101 ---JOB NO 
             4004  --ASSEMBLY
             4002  --POSNO
             S275  --GRADE
             1       --QTY
         UB700511 --PROFILE
      I want this information to be stored in table
      create table ot_drawings (job_no varchar2(12),assembly varchar2(12),posno varchar2(12),grade varchar2(5),qty number,profile varvhar2(12), len  number);