Haider Hussain wrote:the best suggestion is "don't bother modifying the table itself'.
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.
column order is not important.Column order is not important in theory and most of practical cases like where are not many columns and not too many rows.