SQL - How to add new column in the existing table at our desired location?

GeekInterview.com > Interview Questions > Oracle > SQL

Go To First | Previous Question | Next Question

SQL | Question 158 of 169

How to add new column in the existing table at our desired location?

Total Answers and Comments: 4

Last Update: September 12, 2008 Asked by: vijay.akki

Sponsored Links

Best Rated Answer

—

Submitted by: atmarammuduli

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.

Above answer was rated as good by the following members:
praveentn, seenu333p, shiiva

May 30, 2008 02:22:33

atmarammuduli

Member Since: December 2007 Contribution: 8

RE: How to add new column in the existing table at our desired location?

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.

Is this answer useful? Yes | No

1 1

Overall Rating: -N/A-

June 10, 2008 06:46:47

dineshchaini

Member Since: August 2006 Contribution: 6

RE: How to add new column in the existing table at our desired location?

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

Is this answer useful? Yes | No

2 0

Overall Rating: +2

July 17, 2008 04:45:17

Elavarasi

Member Since: July 2008 Contribution: 1

RE: How to add new column in the existing table at our desired location?

alter table table_name add column_name datatype

Is this answer useful? Yes | No

1 2

Overall Rating: -1

September 12, 2008 04:06:21

mahato.neelima

Member Since: September 2008 Contribution: 2

RE: How to add new column in the existing table at our desired location?

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));

Is this answer useful? Yes | No

Go To Top