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: Narayana Vyas Kondreddi <answer_me_at_hotmail.com>
Date: Mon, 24 Sep 2001 11:51:09 +0530
Message-ID: <xdAr7.511$YP.17857@news.cpqcorp.net>


Yes you can, as long as the table DDL of Table1 and Table2 are same, otherwise you will have to include a column list in INSERT and SELECT statements.

--
HTH,
Vyas
SQL Server FAQ, articles, code samples,
best practices, interview questions and much more @
http://vyaskn.tripod.com/


Alan <alanpltse_at_yahoo.com.au> wrote in message
news:9njsfg$7j9$1_at_merki.connect.com.au...

> 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
>
>
Received on Mon Sep 24 2001 - 01:21:09 CDT

Original text of this message

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