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****8815 select 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 类型);