把where 条件改一下,就行了!具体调整如下: update tb_dic_hx_yljgzdb t set t.yljgdm=(select j.yljgdm||'360824' from tb_dic_hx_yljgzdb j where t.yljgdm=j.yljgdm AND t.yljgdm like 'PT%' and length(t.yljgdm)<14 and length(t.yljgdm)>8 )
update tb_dic_hx_yljgzdb t set t.yljgdm=t.yljgdm||'360824' where t.yljgdm like 'PT%' and length(t.yljgdm)<14 and length(t.yljgdm)>8
update tb_dic_hx_yljgzdb t set t.yljgdm=(select j.yljgdm||'360824' from tb_dic_hx_yljgzdb j
where t.yljgdm=j.yljgdm AND t.yljgdm like 'PT%' and length(t.yljgdm)<14 and length(t.yljgdm)>8 )