Re: How set Auto_Increment from a select?
Posted by: Peter Brawley
Date: August 19, 2014 10:55AM

We can't just make up syntax. Alter Table does not accept a Select expression. Do your Select, then write the required literal Alter Table command. Or PREPARE the command.

Note too that for this to be sound, you need to prevent updates to the `ai` column while your correction is running.

Options: ReplyQuote


Subject
Written By
Posted
Re: How set Auto_Increment from a select?
August 19, 2014 10:55AM


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.