HOWTO Alter a Column in a Table Posted on August 17, 2006 by Frank Kim alter table [table name] modify [column name] [column type] For example: alter table user modify login varchar2(100) Related posts: How to Alter Table Best Practices for Creating Tables user-defined property type gotcha’s SQL Delete in One Table Based on Values in Another Table SQL Insert in One Table Based on Values in Another Table
