Oracle 批量更新截取一张表字段

1.备份表

create table cust_info_v as select * from cust_info;

2.查看截取后的字段值
select SUBSTR(cb_id,3) from cust_info_v where  cb_id like '01-%';

3.更新数据表
UPDATE cust_info SET cb_id = REPLACE(cb_id, cb_id, SUBSTR(cb_id,4)) where  cb_id like '01-%';
drop  table  cust_info_v;