title: Oracle update 2 tables in one query
body: <p>I have 2 tables with same column name
  and same condition for update</p>
  <p>does I can run it with single query (without create view or something like this)</p>
  <p>this is the 2 query that I want to combine to single query</p>
  <pre><code>update client set  cityid =76  where cityid =2 
  update agent_ set  cityid =76  where cityid =2 
  </code></pre>
  <p>Thanks</p>