title: Rename multiple tables with single command
body: <p>It's possible with mysql as mentioned here:</p>
  
  <p><a href="https://www.electrictoolbox.com/rename-multiple-tables-mysql/" rel="nofollow noreferrer">https://www.electrictoolbox.com/rename-multiple-tables-mysql/</a></p>
  
  <p>Does similar action possible with oracle ?</p>
  
  <p>Something like :</p>
  
  <pre><code>Alter table tbl1 rename to new1, tbl2 to new2;
  </code></pre>