title: How to insert a column to an existing table?
body: <p>My table name <code>userdetails</code></p>
  
  <p>I want to insert a new column <code>mob</code> after <code>location</code> column.</p>
  
  <p>I tried using the code</p>
  
  <pre><code>alter table userdetails 
  add mob varchar2(10) after location;
  </code></pre>
  
  <p>but its showing error</p>
  
  <blockquote>
    <p>ORA-01735: invalid ALTER TABLE option</p>
  </blockquote>
  
  <p>Please help me.</p>
  
  <p>I am using oracle10g.</p>