RE: [Q] ORACLE support bilk insert like SQL server??
- From: "Baumgartel, Paul" <paul.baumgartel@xxxxxxxxxxxxxxxxx>
- To: mccdba1@xxxxxxxxx, oracle-l@xxxxxxxxxxxxx
- Date: Mon, 5 May 2008 12:35:48 -0400
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@xxxxxxxxxxxxxxxxx
www.credit-suisse.com
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of dba1 mcc
Sent: Monday, May 05, 2008 11:49 AM
To: Goulet, Dick; oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxxx> 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@xxxxxxxxxxxxx
45 Bartlett St. / Marlborough, MA 01752
Together: the Collaborative Business Experience
______________________________________________________________
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of dba1 mcc
Sent: Monday, May 05, 2008 10:46 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: [Q] ORACLE support bilk insert like SQL server??
Does any version of ORACLE support "bulk insert" like SQL
server? I search on Google and can NOT find any info.
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
==============================================================================
Other related posts:
