Saturday 14 September 2013

Is there a way to add column at a specified position?

Is there a way to add column at a specified position?

Consider this inital table I have created:
CUSTOMER_ID ACC_NO ACC_BALANCE
----------- ------ -----------
100 200 1000
101 150 4000
102 350 2000
103 450 2500
104 550 2200
Now I want to add another column customer_name into the table. I used:
alter table bank_account add (Customer_name varchar2(30));
and the column is being inserted as the last column in the table whereas I
want the column to be added to the table as the second column. Now the SQL
code I mentioned is unable to do so. So how can I add the column at a
specified position? Is it even possible in SQL?

No comments:

Post a Comment