1.SQL执行【解决的是创建项目时,“备注”存储长度不够2000的问题】:
alter table PM_PROJECT rename column remark to remark_bak;
alter table PM_PROJECT add remark clob;
update PM_PROJECT set remark=remark_bak;
alter table PM_PROJECT drop column remark_bak;
commit;
cmd窗口:
SQL> desc PM_PROJECT;