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

Re: Inserting from comma deliminated file

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Sat, 09 Oct 2004 12:30:38 -0700
Message-ID: <1097350323.134128@yasure>


Rich Sias wrote:

> 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

Does your Oracle have a version?

  1. SQL*Loader
  2. External Tables
  3. UTL_FILE
-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)
Received on Sat Oct 09 2004 - 14:30:38 CDT

Original text of this message

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