Ashish Karalkar wrote:
> Hello All,
>
> I am having a table with 5 columns.
> I want to add another column by altering the table at 2nd position
> constraint is that I can not drop and recreate the table as column
> ordering is of importance.
> Is there anyway to do so.
No. However, you could create a view with the column ordering you want,
after adding the new column.
Sean