oracle 如何将同一表中的某一列更新到另一列
=======================================
create table KKK_TEST
(
A VARCHAR2(20),
B VARCHAR2(20),
ID NUMBER not null
)
-------------------------------
ID A B
1 aaaaaa
2 bbbbbb
3 cccccc
-----------------------------------
merge into kkk_test k
using (select k1.id,k1.a from kkk_test k1) kk
on (k.id = kk.id)
when matched then update set k.b = kk.a
结果
-------------------------------
ID A B
1 aaaaaa aaaaaa
2 bbbbbb bbbbbb
3 cccccc cccccc
-----------------------------------