Re: Loading data into a table from the file

From: Dwayne K. Lanclos <lanclosd_at_bcstec.ca.boeing.com>
Date: Thu, 30 Jun 1994 13:00:04 GMT
Message-ID: <Cs7o45.6EA_at_bcstec.ca.boeing.com>


Semyon Basin (sb63_at_namaste.cc.columbia.edu) wrote:
> I have a newbie question.
> Since I do not know where the FAQ is, could you please help me.
> How do I load data into a table directly from a disk file?
> I know a little bit of INGRES and they have something like this:
> COPY table FROM 'disk_file';
> Thanx in advance.

I would use SQL*Loader. You build a little script file that tells it what your fields are and in which columns of the file they begin. Oracle does the rest.

-- 
----------
Dwayne K. Lanclos		lanclosd_at_lacmhs.boeing.com

"War doesn't determine who's right, just who's left."
Received on Thu Jun 30 1994 - 15:00:04 CEST

Original text of this message