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

From: Igor Neyman <ineyman_at_perceptron.com>
Date: Mon, 5 May 2008 11:49:26 -0400
Message-ID: <F4C27E77F7A33E4CA98C19A9DC6722A202EA414B@EXCHANGE.corp.perceptron.com>

For Inserts in PL/SQL look for "FORALL" in the docs.

---

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Goulet, Dick Sent: Monday, May 05, 2008 11:21 AM
To: mccdba1_at_yahoo.com; oracle-l_at_freelists.org Subject: RE: [Q] ORACLE support bilk insert like SQL server??

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>

--
http://www.freelists.org/webpage/oracle-l

Received on Mon May 05 2008 - 10:49:26 CDT