摘要:
实现的是将a表中的a1 更换成b表中的b2,条件是a1 = b1,并且a1和b1都是唯一的。update a set a.a1=(select b2 from a,b where a.a1=b.b1 )where a.a1=(select b1 from a,b where a.a1=b.b1 )select * from aselect * from b-- Create tablecreate table A( A1 VARCHAR2(10), A2 VARCHAR2(10), A3 VARCHAR2(10))tablespace FWZCGL pctfree 10 initrans 1. 阅读全文