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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Inserting multiple rows with one INSERT statement

Re: Inserting multiple rows with one INSERT statement

From: Filip Hanik <fhanik_at_digitalworkforce.net>
Date: Thu, 1 Jul 1999 11:13:22 -0700
Message-ID: <lbOe3.58$_A1.15763@typhoon-sf.snfc21.pbi.net> 





INSERT INTO tblEmployees (EMPLID, NAME) select PERSON_ID, NAME FROM
tblPerson;



Filip




Matt Randle <matt_at_imat.demon.co.uk> wrote in message
news:930852355.21001.0.nnrp-03.d4e48d0d_at_news.demon.co.uk...


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


> INSERT statement ??


>


> Thanks,


>


> Matt.


>


>




Received on Thu Jul 01 1999 - 13:13:22 CDT












Original text of this message













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