Re: How to import .csv file to a table?

From: Justin Cave <jcave_at_ddbcinc.com>
Date: 10 Mar 2004 15:11:30 -0800
Message-ID: <c83193c7.0403101511.17979423@posting.google.com>

"gexin" <gexin.chen_at_ncr.com> wrote in message news:<404f01bc_at_rpc1284.daytonoh.ncr.com>...
> I have experience to import below kinds of text file into a table, but how
> can I import .csv file in table?

If you're trying to import the data into Oracle, the easiest way is probably to use SQL*Loader or external tables. Those utilities are specifically designed to import text files into the database and is a lot easier than writing your own code to parse the file and insert the data.

Justin Cave
Distributed Database Consulting, Inc.
http://www.ddbcinc.com/askDDBC Received on Wed Mar 10 2004 - 17:11:30 CST