Re: mysql "LOAD DATA" equivalent in Oracle?
From: David Portabella <david.portabella_at_gmail.com>
Date: Tue, 18 Nov 2008 06:25:16 -0800 (PST)
Message-ID: <5529bc4f-4236-41f0-8e5d-1284d1af87fa@d36g2000prf.googlegroups.com>
Date: Tue, 18 Nov 2008 06:25:16 -0800 (PST)
Message-ID: <5529bc4f-4236-41f0-8e5d-1284d1af87fa@d36g2000prf.googlegroups.com>
On Nov 18, 11:49 am, Thomas Kellerer <YQDHXVLMU..._at_spammotel.com>
wrote:
> David Portabella, 18.11.2008 11:36:
>
> > I am using the query in MySql to import data from a tabular file:
> > +++++++++++++++++++++
> > LOAD DATA LOCAL INFILE '/file1.tab'
> > INTO TABLE table1
> > FIELDS TERMINATED BY '\t'
> > LINES TERMINATED BY '\n'
> > (column1, column2, column3);
> > +++++++++++++++++++++
>
> > what is the equivalent to this in Oracle?
>
> SQL*Loaderhttp://download-uk.oracle.com/docs/cd/B19306_01/server.102/b14215/par...
>
> or external tables:http://download.oracle.com/docs/cd/B19306_01/server.102/b14220/schema...
>
> Thomas
Great, thanks!
DAvid Received on Tue Nov 18 2008 - 08:25:16 CST