Re: Inserting multiple rows with one INSERT statement

From: Christopher Beck <clbeck_at_us.oracle.com>
Date: Thu, 01 Jul 1999 18:12:39 GMT
Message-ID: <377cae22.19097711@inet16.us.oracle.com>

On Thu, 1 Jul 1999 18:59:27 +0100, "Matt Randle" <matt_at_imat.demon.co.uk> wrote:

>Does anyone know if you can insert multiple rows into a table with one
>INSERT statement ??

You can do the following...

  insert into T ( select * from T1 );

hope this helps.

chris.

>
>Thanks,
>
>Matt.
>

--
Christopher Beck
Oracle Corporation
clbeck_at_us.oracle.com
Reston, VA.

---

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Thu Jul 01 1999 - 13:12:39 CDT