title: Updating a table in Oracle with two tables in where clause
body: <p>I have the following query, which works in MySQL, and I need help&amp;hints to rewrite it for Oracle 11g. (I'm new to PL/SQL..)</p>
  
  <pre><code>update table1 n, table2 t
  set n.col1 = t.col1, n.col2 = t.col2
  where t.col3 = n.col3;
  </code></pre>