title: PL/SQL - Update multiple rows in the target table from one row in the source table
body: <p>I'm using a merge statement to merge two tables where one row in the source table may update multiple rows in the target table.</p>
  
  <p>It goes a bit like this</p>
  
  <pre><code>MERGE TABLE1 A
  USING (SELECT EMP_CODE, DAYS_OFF FROM TABLE2) B
  ON (A.ID = B.EMP_CODE)
  WHEN MATCHED THEN
  UPDATE SET A.DAYS_OFF = B.DAYS_OFF;
  </code></pre>
  
  <p>However, when i attempt this, i get <code>SQL Error: ORA-30926: unable to get a stable set of rows in the source tables</code></p>
  
  <p>Is there any other way i can do this?</p>