Adding a new Column in a Table in between existing Columns
519961Sep 6 2006 — edited Sep 6 2006Hello,
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.