6 Replies Latest reply on Dec 8, 2012 11:37 AM by Haider Hussain

    column between 2 existing columns

    Haider Hussain
      Hi ,

      I have a table (my_tab) having 2 columns (Col1 and Col 3). I wish to add a new column (Col2) between Col1 and Col3.
      Two ways I could think are: 1. Create a view on the table having the column sequence as Col1,Col2,Col3

      2. Just like point 1, introduce Col2 while writing theselect query for the table.

      Could you please suggest some other methods of doing this , sayat table level itself.