UPDATE USER SET NUMBER = '8101'||SUBSTR(NUMBER,5) WHERE SUBSTR(NUMBER,0,4) = '2103';
create table t_user(id int, num number);insert into t_user values(1,2103001); insert into t_user values(2,2103002); insert into t_user values(3,2103003);update t_user set num='8103'||substr(num,5,3);select * from t_user;
UPDATE USER
SET NUMBER = '8101'||SUBSTR(NUMBER,5)
WHERE SUBSTR(NUMBER,0,4) = '2103';
create table t_user(id int, num number);insert into t_user values(1,2103001);
insert into t_user values(2,2103002);
insert into t_user values(3,2103003);update t_user set num='8103'||substr(num,5,3);select * from t_user;