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 -> Inserting from comma deliminated file

Inserting from comma deliminated file

From: Rich Sias <zbikie_at_gmail.com>
Date: 9 Oct 2004 10:52:51 -0700
Message-ID: <d98bdb57.0410090952.27141b23@posting.google.com>


I have a comma deliminated file with the first 12 columns to load into an Oracle table. Cols 13 and up will go into another table. IDs from both will be put into a key file to match up both items.

Does anyone have a method to load up form this for the first table? I also have a sequence to load into a 13th column. At one point I thought I could open the CDF as a table and select on it and insert into another table. I cannot find that reference now.

Please include URLs etc for reference. I have searched the docs on Oracle but was unable to find the info.

Rich Sias Received on Sat Oct 09 2004 - 12:52:51 CDT

Original text of this message

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