RE: [Q] ORACLE support bilk insert like SQL server??
Date: Mon, 5 May 2008 12:35:48 -0400
Message-ID: <21469B88E0EA11498818517F2103353101C66307@EPRI17P32001A.csfb.cs-group.com>
You can, from 9i onward, create an external table from the file, then
use SQL to insert into a standard table, e.g.
insert into standard_table select * from external_table;
or
create table new_table as select * from external_table;
Paul Baumgartel
CREDIT SUISSE
Information Technology
Prime Services Databases Americas
One Madison Avenue
New York, NY 10010
USA
Phone 212.538.1143
paul.baumgartel_at_credit-suisse.com
www.credit-suisse.com
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of dba1 mcc
Sent: Monday, May 05, 2008 11:49 AM
To: Goulet, Dick; oracle-l_at_freelists.org
Subject: RE: [Q] ORACLE support bilk insert like SQL server??
What I want is use "insert" statement read "external file" NOT PL/SQL or SQl*Loader.
"Goulet, Dick" <richard.goulet_at_capgemini.com> wrote:
In Pro*C look under Array Processing.
In PL/SQL look under Bulk Collect
In SQL*Loader look under columnarrayrows and direct path load
Dick Goulet / Capgemini North America P&C / East Business Unit Senior Oracle DBA / Hosting Office: 508.573.1978 / Mobile: 508.742.5795 / www.capgemini.com Fax: 508.229.2019 / Email: richard.goulet_at_capgemini.com 45 Bartlett St. / Marlborough, MA 01752 Together: the Collaborative Business Experience ______________________________________________________________server? I search on Google and can NOT find any info.
________________________________
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of dba1 mcc Sent: Monday, May 05, 2008 10:46 AM To: oracle-l_at_freelists.org Subject: [Q] ORACLE support bilk insert like SQL server?? Does any version of ORACLE support "bulk insert" like SQL
Thanks.
Be a better friend, newshound, and know-it-all with Yahoo!
Mobile. Try it now.
<http://us.rd.yahoo.com/evt=51733/*http:/mobile.yahoo.com/;_ylt=Ahu06i62
sR8HDtDypao8Wcj9tAcJ%20>
Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try
it now.
<http://us.rd.yahoo.com/evt=51733/*http://mobile.yahoo.com/;_ylt=Ahu06i6
2sR8HDtDypao8Wcj9tAcJ>
Please access the attached hyperlink for an important electronic communications disclaimer:
http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html
-- http://www.freelists.org/webpage/oracle-lReceived on Mon May 05 2008 - 11:35:48 CDT