alter table tableName add temp varchar2(30); 添加一列 update tableName set temp=columnName; 将一列复制给另外一列 alter table tableName drop column columnName; 删除原有列 alter table tableName rename column temp to columnName; 列重命名