Re: How to merge two or three different tables in one?
Posted by:
Ron Mey-Ami
Date: September 07, 2008 08:38PM
You can do something like this (Note that respective columns must be of the same type)
INSERT INTO new_table
SELECT myColumn1, myColumn2,myColumn3
FROM old_table1
UNION
SELECT myColumn1, myColumn2,myColumn3
FROM old_table2
UNION
SELECT myColumn1, myColumn2,myColumn3
FROM old_table3;
Subject
Written By
Posted
September 07, 2008 07:24PM
Re: How to merge two or three different tables in one?
September 07, 2008 08:38PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.