title: How to rename multiple columns in oracle using one Alter table statement?
body: <p>The only thing I found is renaming one column at a time:</p>
  
  <pre><code>ALTER TABLE table_name
  RENAME COLUMN old_name TO new_name;
  </code></pre>
  
  <p>I read Oracle documentations, and couldn't get the answer for many columns at a time .</p>
  
  <p>Ref: <a href="https://docs.oracle.com/javadb/10.6.2.1/ref/rrefsqljrenamecolumnstatement.html" rel="nofollow noreferrer">https://docs.oracle.com/javadb/10.6.2.1/ref/rrefsqljrenamecolumnstatement.html</a></p>