aaa948771854的博客

alter table case_basicinfo rename column staff_id to staff_id_bak;alter table case_basicinfo add staff_id clob;update case_basicinfo set staff_id=staff_id_bak;alter table case_basicinfo drop column staff_id_bak;

登录sys账户select session_id from v$locked_object;//SELECT sid, serial#, username, osuser FROM v$session where sid = session_id;SELECT sid, serial#, username, osuser FROM v$session where sid = '1909';//ALTER SYSTEM KILL SESSION 'sid,serial#';ALTER S.

//130****8815select REPLACE(contno,SUBSTR(contno,4,4), '****') as contno from lccont a WHERE a.contno = '13003038815';

//先将需要修改的字段改名进行备份alter table CASE_DOCU_SIX_ORDER_CIACT rename column ILLEGAL_FACTS to ILLEGAL_FACTS1;//新建一个字段，long类型，由varchar2变成 clob需要以long过度alter table CASE_DOCU_SIX_ORDER_CIACT add ILLEG...

索引失效重建索引alterindexpk_kc03rebuild查询oracle索引alterindexpk_kc03rebuild

删除alter table table_name drop (documentNo);增加alter table table_name add(column 类型);