Re: Problem merging two tables
Posted by: Rick James
Date: May 28, 2010 10:31AM

How does it know to change 80 to 890? Do you need this to that particular number?

How about simply
INSERT INTO new SELECT id+1000, ... FROM other;
(where 1000 is big enough to avoid dups)
Then do INSERTs like that on all such tables.

Options: ReplyQuote

Written By
Re: Problem merging two tables
May 28, 2010 10:31AM

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.