MERGE INTO temp_a pp
USING (select l.id,nvl(r.na,'') na from (select 3 id from dual) l,(select id,na from temp_a where id=3) r where l.id=r.id(+)) np --表示这条记录在附表中一定要存在。
ON (pp.id=np.id)
when MATCHED then
update
set pp.na=trunc(dbms_random.value(10,100))||''
where pp.id=3
WHEN NOT MATCHED THEN
insert
values(3,'aa')
where rownum < 2
USING (select l.id,nvl(r.na,'') na from (select 3 id from dual) l,(select id,na from temp_a where id=3) r where l.id=r.id(+)) np --表示这条记录在附表中一定要存在。
ON (pp.id=np.id)
when MATCHED then
update
set pp.na=trunc(dbms_random.value(10,100))||''
where pp.id=3
WHEN NOT MATCHED THEN
insert
values(3,'aa')
where rownum < 2