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