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
类似这样试试