title: Alter table after keyword in Oracle
body: <pre><code>ALTER TABLE testTable ADD column1 NUMBER(1) DEFAULT 0 NOT NULL AFTER column2;
  </code></pre>
  
  <p>Why can't I use mySql syntax in Oracle too? The above command works in MySql. Can you give me an equivalent that works?</p>
  
  <hr>
  
  <pre><code>Error report:
  SQL Error: ORA-01735: invalid ALTER TABLE option
  01735. 00000 -  "invalid ALTER TABLE option"
  </code></pre>
  
  <hr>
  
  <p>I am asking if there is any way to use after clause in Oracle command that I provided?</p>