Question: Update with minus clause
mail8mzFeb 7 2013 — edited Feb 7 2013Hello,
I am using Oracle 11.2, I have two tables with same structure. I need udpate the target table if there is no corresponding row in the source table. Here is the SQL I am thinking. However it does not work! Any suggestion on this SQL?
Update tb_trgt set (delFlag = 1)
Where (id, seq) in
(select id, seq from tb_trgt
minus
select id, seq from tb_src);