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

Home -> Community -> Usenet -> comp.databases.theory -> Re: Insert blocks of data into a table

Re: Insert blocks of data into a table

From: Jonathan Leffler <jleffler_at_earthlink.net>
Date: Tue, 11 Sep 2001 14:13:33 GMT
Message-ID: <3B9E1BEB.6F542BE4@earthlink.net>


Alan wrote:

> Can I use the following command:
>
> Insert into Table1
> Select * from Table2 where Table2.Field1 = '123'
>
> Note: the select statement return more than 1 row

Yes. Wouldn't it have been quicker to try it?

--
Jonathan Leffler (jleffler_at_earthlink.net, jleffler_at_informix.com)
Guardian of DBD::Informix 1.00.PC1 -- see http://www.cpan.org/
#include <disclaimer.h>
Received on Tue Sep 11 2001 - 09:13:33 CDT

Original text of this message

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