mysql "LOAD DATA" equivalent in Oracle?
From: David Portabella <david.portabella_at_gmail.com>
Date: Tue, 18 Nov 2008 02:36:15 -0800 (PST)
Message-ID: <80e0a924-fcc9-41f6-b20e-53e3d9fc7e6e@q26g2000prq.googlegroups.com>
Date: Tue, 18 Nov 2008 02:36:15 -0800 (PST)
Message-ID: <80e0a924-fcc9-41f6-b20e-53e3d9fc7e6e@q26g2000prq.googlegroups.com>
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
Received on Tue Nov 18 2008 - 04:36:15 CST