How to Insert a Column between existing columns?

Hello,
I want to insert a new column in the specified position to a exsited table. But all the default operation of adding column is to append the new column at the tail.

There seems no SQL statement for my purpose.

For example:
The existing table have columns
ID NUMBER(10)
AGE NUMBER(10) I want to insert a new column NAME (VARCHAR2 (30)) between ID and AGE. Then, the expectation should like this.

ID NUMBER(10)
NAME VARCHAR2 (30)
AGE NUMBER(10) Is there some method for this ? Received on Mon Jan 08 2007 - 21:19:44 CST