alter table TABLE_NAME rename column COL1 to COL12;
alter table TABLE_NAME add COL1 VARCHAR2(100);
update TABLE_NAME set COL1 = trim(COL12);
alter table TABLE_NAME drop column COL12;
更改已有数据的字段的类型
最新推荐文章于 2024-02-21 17:45:00 发布
alter table TABLE_NAME rename column COL1 to COL12;
alter table TABLE_NAME add COL1 VARCHAR2(100);
update TABLE_NAME set COL1 = trim(COL12);
alter table TABLE_NAME drop column COL12;