Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: General Question: UNION version multiple INSERTS

Re: General Question: UNION version multiple INSERTS

From: DA Morgan <damorgan_at_psoug.org>
Date: Sun, 15 Oct 2006 20:01:57 -0700
Message-ID: <1160967712.609618@bubbleator.drizzle.com>


Dereck L. Dietz wrote:
> In general, which is more efficient to put data into a table?
>
> 1. Multiple UNION statements or
>
> 2. Multiple INSERT statements

The use of the two is mutually exclusive. What is it you are actually trying to do ... and in what version?

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Sun Oct 15 2006 - 22:01:57 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US