regarding merging of tables [message #70362] |
Mon, 03 June 2002 23:14 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
Sreedhar
Messages: 30 Registered: March 2000
|
Member |
|
|
hi,
i need to merge three tables of same structure, with data into one table. could any one help me out please.
regards,
sreedhar
|
|
|
Re: regarding merging of tables [message #70363 is a reply to message #70362] |
Tue, 04 June 2002 00:13 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
Sujit Mahapatra
Messages: 19 Registered: March 2002
|
Junior Member |
|
|
Try this:
INSERT INTO MERGE_TABLE (SELECT * FROM TABLE1);
Then the other two:
INSERT INTO MERGE_TABLE (SELECT * FROM TABLE2);
INSERT INTO MERGE_TABLE (SELECT * FROM TABLE3);
this should work...
Cheers,
Sujit
|
|
|