Oracle, Updating multiple rows in one query, using prepared statement
<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>