1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47
|
create table company
(
companyid number(1),
bo_id number(1),
setid varchar2(4)
);
Table created.
insert into company values (1, 9, 'val1');
1 row created.
create table iprod
(
companyid number(1),
bo_id number(1),
process_instance number(3),
flag varchar2(1)
);
Table created.
insert into iprod values (1, null, 111, 'Y');
1 row created.
insert into iprod values (2, null, 111, 'N');
1 row created.
commit;
Commit complete.
MERGE INTO iprod lip2
USING (SELECT companyid, bo_id
FROM company
WHERE setid = 'val1') prc1
ON (prc1.companyid = lip2.companyid)
WHEN MATCHED THEN UPDATE
SET lip2.bo_id = prc1.bo_id
WHERE lip2.process_instance = 111
AND lip2.flag = 'Y';
1 row merged.
select * from iprod;
COMPANYID BO_ID PROCESS_INSTANCE FLAG
1 9 111 Y
2 111 N |
Partager