Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Adding a new Column in a Table in between existing Columns

519961Sep 6 2006 — edited Sep 6 2006
Hello,

I have a pretty simple task and I am not sure of the proper syntax that Oracle requires or even if Oracle supports the ability to add a new column in an existing table in between existing columns.

ALTER TABLE tblname ADD COLUMN (newcolumn VARCHAR2(10)) AFTER existingcolumn;

I tried to execute this but i get an error, "Invalid Identifier".

Could someone please help me figure out if this is possible and what I should change to make it work? Thank you.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 4 2006
Added on Sep 6 2006
4 comments
838 views