create table A( name varchar2(20), name2 varchar2(20) )insert into A(name) values('44004251') insert into A(name) values('44004263') insert into A(name) values('44004275') insert into A(name) values('44004275') insert into A(name) values('44004287') insert into A(name) values('44004466') insert into A(name) values('44004366')update A set name2=substr(name,1,6)||'A' select * from A 类似这样试试
update A set name2=substr(name,1,6)||'A' 就是一次更新完啊 只是上千条的话应该没问题啊
update 表名 set ZHEN_DEPT_CODE='A('||substr(XIAN_DEPT_CODE,1,6)||')'
update tb set zhen_dept_code='A('||substr(xian_dept_code,1,6)||')'
name varchar2(20),
name2 varchar2(20)
)insert into A(name) values('44004251')
insert into A(name) values('44004263')
insert into A(name) values('44004275')
insert into A(name) values('44004275')
insert into A(name) values('44004287')
insert into A(name) values('44004466')
insert into A(name) values('44004366')update A set name2=substr(name,1,6)||'A'
select * from A
类似这样试试
就是一次更新完啊 只是上千条的话应该没问题啊