Re: mysql "LOAD DATA" equivalent in Oracle?

David Portabella wrote:
> 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?
>
>
> Regards,
> DAvid

In Oracle either SQL*Loader
http://www.psoug.org/reference/sqlloader.html

or an External Table
http://www.psoug.org/reference/externaltab.html

-- 
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org