with t1 as ( select 1 tid from dual union all select 22 tid from dual union all select 333 tid from dual union all select 4444 tid from dual union all select 55555 tid from dual )select 'V'||lpad(tid,7,'0') c1 from t1 c1 ---------------------- 1 V0000001 2 V0000022 3 V0000333 4 V0004444 5 V0055555
直接改成更新语句就行了update 表 set 空字段 = 'V'||lpad(主键字段,7,'0')
with t1 as
(
select 1 tid from dual union all
select 22 tid from dual union all
select 333 tid from dual union all
select 4444 tid from dual union all
select 55555 tid from dual
)select 'V'||lpad(tid,7,'0') c1
from t1 c1
----------------------
1 V0000001
2 V0000022
3 V0000333
4 V0004444
5 V0055555