title: PL/SQL Update statement return multiple rows
body: <p>I'm trying to update a name column from table test and update from column name2 from test2 table where another two column from both tables have to match.</p>
  
  <p>It gives me error "single row query return multiple row".</p>
  
  <p>How do I return multiple rows? Do I use a for loop? If so, how?</p>
  
  <pre><code>Update Test  
  SET name = (Select name2
              from test2
              where name2.col2 = name.col)
  WHERE EXISTS
    ( SELECT name2
      FROM test2
     WHERE name2.col2 = name.col);
  </code></pre>