The batch update between two table fields is to replace A1 in Table A with B2 in Table B with a1 = b1, and A1 and B1 are unique.

To achieve this, replace A1 in Table A with B2 in Table B. The condition is a1 = b1, and A1 and B1 are unique.

 

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
Select * from B

-- Create Table
Create Table A
(
A1 varchar2 (10),
A2 varchar2 (10 ),
A3 varchar2 (10)
)
tablespace fwzcgl
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64
minextents 1
maxextents unlimited
);
-- Create Table
Create Table B
(
B1 varchar2 (10),
B2 varchar2 (10 ),
B3 varchar2 (10)
)
tablespace fwzcgl
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64
minextents 1
maxextents unlimited
);