atmarammuduli

 Profile Answers by atmarammuduli 

• May 30th, 2008

 

 You cannot do this. You can drop and re-create the table if you insist on the columns being in a particular order. Having the columns in a particular order is pretty much pointless. This question is asked on a regular basis. If you had searched, you should have quite quickly discovered this information.

dineshchaini

 Profile Answers by dineshchaini 

• Jun 10th, 2008

 

Alter Table<Tab_Name> add column <column_name> .. this is allowed in 9i, but when the table fill with data and various constraint then it might not work..

and order of the column in a RDBMS is not at all important as per Codd's rules, any time you can extract any column in any sequesnce.

Dinesh

Elavarasi

 Profile Answers by Elavarasi 

• Jul 17th, 2008

 

alter table table_name add column_name datatype

mahato.neelima

 Profile Answers by mahato.neelima 

• Sep 12th, 2008

 

Syntax : - Alter Table <table_name> ADD Column (<column_name1> <data_type1>[size1], <column_name2> <data_type2>[size2], ...);

Example : - Alter Table Employee ADD Column (Address2 Varchar2(28),Phone2 Number(6));

aniketkatkar

 Profile Answers by aniketkatkar 

• Mar 30th, 2009

 

You cannot do this. for this you must then drop or re-create the table with your order sequence of columns.

fkhalid

 Profile Answers by fkhalid 

• Apr 1st, 2009

 

You can't add the column at desired location but you can create view and put the desired columns in order you required and use that view.

arunmscit86

 Profile Answers by arunmscit86 

• Oct 23rd, 2009

 

Syntax:
--------

Alter table <Table_name> add <Column_name1> <Data_type1> after <Column_Name>;

Example:
-----------

Alter table employee add age int after emp_name;

Ramkiran_79

 Profile Answers by Ramkiran_79 

• Aug 6th, 2010

 

You cannot have user defined syntaxes in Oracle, still it is implemented, following error will be thrown.

 1* alter table employee add (age number(10)) after ename
SQL> /
alter table employee add (age number(10)) after ename
                                         *
ERROR at line 1:
ORA-01735: invalid ALTER TABLE option

panwar_5

 Profile Answers by panwar_5 

• Jan 7th, 2011

 

This can be done eaisly using the keyword after,suppose you want to add a column "name" after the field "id".

Alter table emp add name varchar2 after id