title: Oracle, Updating multiple rows in one query, using prepared statement
body: <p>I know that you can insert multiple rows in a query by using</p>
  
  <pre><code>  INSERT ALL
    INTO mytable (column1, column2, column_n) VALUES (?,?,?)
    INTO mytable (column1, column2, column_n) VALUES (?,?,?)
    INTO mytable (column1, column2, column_n) VALUES (?,?,?)
    SELECT * FROM dual;
  </code></pre>
  
  <p>Is there a way for update as well based on a value? So it would be something like</p>
  
  <pre><code>  UPDATE ALL
    SET mytable (column1, column2, column_n) VALUES (?,?,?)
    SET mytable (column1, column2, column_n) VALUES (?,?,?)
    SET mytable (column1, column2, column_n) VALUES (?,?,?)
    WHERE ID= ?
    SELECT * FROM dual;
  </code></pre>
  
  <p>For instance i have a reviewtable</p>
  
  <pre><code>       reviewid      bookid     authorname   authoremail
            1            1           peter        wdwdd
            2            1           jane         dwdwdw
            3            1           mary         dwdw
  </code></pre>
  
  <p>Is it possible to do a multiple update where bookid = "1" ?</p>