Return-Path: Delivered-To: 2-oracle-l@orafaq.com Received: (qmail 11659 invoked from network); 5 May 2008 11:00:10 -0500 Received: from freelists-180.iquest.net (HELO turing.freelists.org) (206.53.239.180) by static-ip-69-64-49-119.inaddr.server4you.com with SMTP; 5 May 2008 11:00:08 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 0234784C419; Mon, 5 May 2008 11:59:08 -0400 (EDT) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 20632-08; Mon, 5 May 2008 11:59:07 -0400 (EDT) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 6B9C384C44E; Mon, 5 May 2008 11:59:07 -0400 (EDT) Received: with ECARTIS (v1.0.0; list oracle-l); Mon, 05 May 2008 11:20:34 -0400 (EDT) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 7622C84C559 for ; Mon, 5 May 2008 11:20:34 -0400 (EDT) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 16561-08 for ; Mon, 5 May 2008 11:20:34 -0400 (EDT) Received: from SPFSEORB01.capgemini.com (SPFSEORB01.capgemini.com [198.184.232.101]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id B652584C533 for ; Mon, 5 May 2008 11:20:33 -0400 (EDT) X-IronPort-AV: E=Sophos;i="4.27,438,1204498800"; d="scan'208,217";a="4439361" Received: from unknown (HELO mxiorb01.capgemini.com) ([205.223.236.82]) by IRSEORB-C650-01-D2-incoming.capgemini.com with ESMTP/TLS/DHE-RSA-AES256-SHA; 05 May 2008 17:20:45 +0200 Received: from CAONMASTTM02.na.capgemini.com (caonmasttm02.na.capgemini.com [206.245.12.91]) by mxiorb01.capgemini.com (8.13.6/8.13.6) with ESMTP id m45FLHI7023554 for ; Mon, 5 May 2008 17:21:17 +0200 (MEST) Received: from caonmastxr02.na.capgemini.com ([206.245.20.35]) by CAONMASTTM02.na.capgemini.com with InterScan Messaging Security Suite; Mon, 05 May 2008 11:21:15 -0400 Received: from caonmastxm02.na.capgemini.com ([206.245.20.9]) by caonmastxr02.na.capgemini.com with Microsoft SMTPSVC(5.0.2195.6713); Mon, 5 May 2008 11:21:15 -0400 X-MimeOLE: Produced By Microsoft Exchange V6.5 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C8AEC3.A85B6041" Subject: RE: [Q] ORACLE support bilk insert like SQL server?? Date: Mon, 5 May 2008 11:21:14 -0400 Message-ID: <746B47FAF6783042B256C0E7CC0795CD02A70813@caonmastxm02.na.capgemini.com> In-Reply-To: <265409.90271.qm@web65701.mail.ac4.yahoo.com> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: [Q] ORACLE support bilk insert like SQL server?? References: <265409.90271.qm@web65701.mail.ac4.yahoo.com> From: "Goulet, Dick" To: , X-OriginalArrivalTime: 05 May 2008 15:21:15.0572 (UTC) FILETIME=[A8E86F40:01C8AEC3] X-imss-version: 2.050 X-imss-result: Passed X-imss-approveListMatch: *@capgemini.com X-archive-position: 7819 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: richard.goulet@capgemini.com Precedence: normal Reply-to: richard.goulet@capgemini.com List-help: List-unsubscribe: List-software: Ecartis version 1.0.0 List-Id: oracle-l X-List-ID: oracle-l List-subscribe: List-owner: List-post: List-archive: X-list: oracle-l X-Virus-Scanned: Debian amavisd-new at localhost.localdomain ------_=_NextPart_001_01C8AEC3.A85B6041 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable In Pro*C look under Array Processing. =20 In PL/SQL look under Bulk Collect =20 In SQL*Loader look under columnarrayrows and direct path load =20 ______________________________________________________________ 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@capgemini.com 45 Bartlett St. / Marlborough, MA 01752 Together: the Collaborative Business Experience=20 ______________________________________________________________ ________________________________ From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of dba1 mcc Sent: Monday, May 05, 2008 10:46 AM To: oracle-l@freelists.org Subject: [Q] ORACLE support bilk insert like SQL server?? =20 Does any version of ORACLE support "bulk insert" like SQL server? I search on Google and can NOT find any info. Thanks. =20 ________________________________ Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now. =20 ------_=_NextPart_001_01C8AEC3.A85B6041 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

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@capgemini.com=
45 Bartlett = St. / Marlborough, MA 01752

Together: the Collaborative = Business Experience
______________________________________________________________=

From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] = On Behalf Of dba1 mcc
Sent: Monday, May 05, = 2008 10:46 AM
To: = oracle-l@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.

------_=_NextPart_001_01C8AEC3.A85B6041-- -- http://www.freelists.org/webpage/oracle-l