update A set A = 'AA',b = decode(no,1,'BB',b); commit;
SQL> create table ta (no number,a varchar(20),b varchar(20));表已创建。SQL> insert into ta values(1,'gg','mm');已创建 1 行。 SQL> insert into ta values(2,'dd','mm');已创建 1 行。 SQL> select * from ta; NO A B ---------- -------------------- -------------------- 1 gg mm 2 dd mmSQL> update ta set a='AA',b=(decode(ta.no,1,'BB',ta.b));已更新2行。SQL> commit;提交完成。SQL> select * from ta; NO A B ---------- -------------------- -------------------- 1 AA BB 2 AA mm
commit;
SQL> insert into ta values(2,'dd','mm');已创建 1 行。
SQL> select * from ta; NO A B
---------- -------------------- --------------------
1 gg mm
2 dd mmSQL> update ta set a='AA',b=(decode(ta.no,1,'BB',ta.b));已更新2行。SQL> commit;提交完成。SQL> select * from ta; NO A B
---------- -------------------- --------------------
1 AA BB
2 AA mm