Add enum value to existing table?
Posted by: Roy Wilkinson
Date: June 25, 2014 12:22AM

Color me novice.

If I create a table that has an 'enum' column, is there any way to _add_ to the allowed 'enum' values? If not, is there some way to create a new table (with the expanded 'enum' values), copy the old table to it, and then replace the old table with the new one?

Thanks for any wisdom you can provide on this.

- Roy

Options: ReplyQuote


Subject
Written By
Posted
Add enum value to existing table?
June 25, 2014 12:22AM


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.