Re: Inserting from comma deliminated file

From: Ana C. Dent <anacedent_at_hotmail.com>
Date: Sat, 09 Oct 2004 18:40:02 GMT
Message-ID: <Xns957D76AF83C5BSunnySD@68.6.19.6>

zbikie_at_gmail.com (Rich Sias) wrote in
news:d98bdb57.0410090952.27141b23_at_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
>

http://downloadwest.
oracle.com/docs/cd/B10501_01/server.920/a96540/statements_73a.htm#2093 662

P.S.
undo the line wraps

Google is your friend

also http://asktom.oracle.com Received on Sat Oct 09 2004 - 13:40:02 CDT