Re: [Q] ORACLE support bilk insert like SQL server??
Date: Mon, 5 May 2008 09:55:17 -0700 (PDT)
perhaps an external table is what you are wanting?? Then the insert statement could use an append hint.
Say you had an external file called X. You can create an external table (9i and later) that allows you to access that external file from the database like a database table. This is called an external table. Call this table TAB_X.
You could then use an insert /*+ APPEND */ command to use direct mode to read the external table data and import it into the database:
insert /*+ APPEND */ into NEW_TAB select * from TAB_X.
Is this what you are wanting?
Robert G. Freeman
Oracle Database 11g New Features (Oracle Press) Portable DBA: Oracle (Oracle Press)
Oracle Database 10g New Features (Oracle Press) Oracle9i RMAN Backup and Recovery (Oracle Press) Oracle9i New Feature
Blog: http://robertgfreeman.blogspot.com (Oracle Press)
- Original Message ---- From: dba1 mcc <mccdba1_at_yahoo.com> To: "Goulet, Dick" <richard.goulet_at_capgemini.com>; oracle-l_at_freelists.org Sent: Monday, May 5, 2008 9:48:52 AM 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 AmericaP&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
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.
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. Received on Mon May 05 2008 - 11:55:17 CDT