title: Database: Oracle Add new column but not the last column (sequence)?
body: <p>One question</p>
  
  <p>Database: Oracle </p>
  
  <p>This is the stmt (Desc.: chnage type VARCHAR to CLOB)</p>
  
  <pre><code>ALTER TABLE XX
   ADD (TEMP_Value CLOB);
  UPDATE XX SET TEMP_Value=Value;
  COMMIT;
  ALTER TABLE XX DROP COLUMN Value;
  ALTER TABLE XX
  RENAME COLUMN TEMP_Value TO Value;
  </code></pre>
  
  <p>the problem:
  The new clob-column is the last column in the XX table (normally).
  If value second was now is the last column, How to change the sequence</p>