Copy data from two table to another table with a different Structure
Posted by:
ken l
Date: January 12, 2012 01:12PM
Hello,
I have a query that I cant seem to find a solution for.
I have a table A AND B they both have an identiy column called ID the problem with this the structures are different so i cant use
INSERT INTO C select * FROM A
it tells me Column name or number of supplied values does not match table definition.
Subject
Written By
Posted
Copy data from two table to another table with a different Structure
January 12, 2012 01:12PM
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.