RE: [Q] ORACLE support bilk insert like SQL server??
- From: dba1 mcc <mccdba1@xxxxxxxxx>
- To: "Goulet, Dick" <richard.goulet@xxxxxxxxxxxxx>, oracle-l@xxxxxxxxxxxxx
- Date: Mon, 5 May 2008 08:48:52 -0700 (PDT)
What I want is use "insert" statement read "external file" NOT PL/SQL or
SQl*Loader.
"Goulet, Dick" <richard.goulet@xxxxxxxxxxxxx> wrote: v\:*
{behavior:url(#default#VML);} o\:* {behavior:url(#default#VML);} w\:*
{behavior:url(#default#VML);} .shape {behavior:url(#default#VML);}
st1\:*{behavior:url(#default#ieooui) } 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.
---------------------------------
Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now.
- Follow-Ups:
- RE: [Q] ORACLE support bilk insert like SQL server??
- From: Goulet, Dick
- RE: [Q] ORACLE support bilk insert like SQL server??
- From: Baumgartel, Paul
- References:
- RE: [Q] ORACLE support bilk insert like SQL server??
- From: Goulet, Dick
Other related posts:
- » RE: [Q] ORACLE support bilk insert like SQL server??
- » RE: [Q] ORACLE support bilk insert like SQL server??
- » RE: [Q] ORACLE support bilk insert like SQL server??
- » RE: [Q] ORACLE support bilk insert like SQL server??
- » RE: [Q] ORACLE support bilk insert like SQL server??
- » Re: [Q] ORACLE support bilk insert like SQL server??
- » RE: [Q] ORACLE support bilk insert like SQL server??
- » Re: [Q] ORACLE support bilk insert like SQL server??
- RE: [Q] ORACLE support bilk insert like SQL server??
- From: Goulet, Dick
- RE: [Q] ORACLE support bilk insert like SQL server??
- From: Baumgartel, Paul
- RE: [Q] ORACLE support bilk insert like SQL server??
- From: Goulet, Dick