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