RE: [Q] ORACLE support bilk insert like SQL server??

From: Baumgartel, Paul <paul.baumgartel_at_credit-suisse.com>
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 
	______________________________________________________________
	

________________________________
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
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


--
http://www.freelists.org/webpage/oracle-l
Received on Mon May 05 2008 - 11:35:48 CDT

Original text of this message