Add one table records from one table to another

[evergreean43]

I have a table (called first) where I would like to take another table (called second) and add all of the records to table first.

My attempt doesnt work:

copy from table second to table first;

Here is an example of what I want to do:
table first

id    name
1     Jones
2     Richards
3     Carson

table second

id    name
4     Baker
5     Johnson
6     Hart
7     Barnes

table first after adding table second records

id    name
1     Jones
2     Richards
3     Carson
4     Baker
5     Johnson
6     Hart
7     Barnes

 

[gunjan14]

Hi,

You can achieve by executing this

insert into table1
select * from table2;

Regards,
Gunjan

 

[Dagon]

The "copy" command isn't really part of SQL. It's an feature in SQL*Plus which allows you to copy data between different databases. It's not really suitable if all the tables are on the same database.

 

[Beilstwh]

You can't use a simple "select * into..." if you want to use a new sequence number for the id#. Use the following

insert into table1
select my_seq.nextval,name
from table2;

This is assuming that you are using a sequence for the insert into table1.

Bill
Oracle DBA/Developer
New York State, USA