- 表中已存有数据:ALTER table tableName MODIFY (字段名 字段类型(长度)); eg: alter table dpsm_dm_drugslog modify(person VARCHAR2(30));
- 表中未存有数据:ALTER TABLE TABLENAME MODIFY ID CHAR(16) eg: alter table dpsm_dm_drugslog modify person VARCHAR2(30);
转载于:https://www.cnblogs.com/4AMLJW/p/ghyfgjghf.html