Re: mysql "LOAD DATA" equivalent in Oracle?

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*Loader
http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b14215/part_ldr.htm

or external tables:
http://download.oracle.com/docs/cd/B19306_01/server.102/b14220/schema.htm#i36180

Thomas Received on Tue Nov 18 2008 - 04:49:26 CST