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.

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 4 2006

Added on Sep 6 2006

4 comments

838 views