Home » SQL & PL/SQL » SQL & PL/SQL » Changing Order Of Columns after altering table
Changing Order Of Columns after altering table [message #285725] Wed, 05 December 2007 07:09 Go to next message
thisisnatesh
Messages: 92
Registered: March 2007
Member
Hi

I have a table with 3 columns. Now i altered the table
and added a new column. This new column will be by
default at the end of the table. can i move or change
the position of column in the table, like moving it from
5 to 3rd column?

Thanks in Advance

Nat
Re: Changing Order Of Columns after altering table [message #285726 is a reply to message #285725] Wed, 05 December 2007 07:12 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
Don't bother.
Change the order of columns in your select-clause.
Re: Changing Order Of Columns after altering table [message #285727 is a reply to message #285725] Wed, 05 December 2007 07:12 Go to previous messageGo to next message
Michel Cadot
Messages: 64098
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1/ In relational model column order is meaningless, you have to always name the columns in ALL statements.

2/ If you really need it (for performances or storage reason), you have to use dbms_redefinition package

Regards
Michel

[Updated on: Wed, 05 December 2007 07:22]

Report message to a moderator

Re: Changing Order Of Columns after altering table [message #285737 is a reply to message #285727] Wed, 05 December 2007 07:22 Go to previous message
thisisnatesh
Messages: 92
Registered: March 2007
Member
Thanks MIC
Previous Topic: Columns in a Compound primary key
Next Topic: Finding the difference between dates
Goto Forum:
  


Current Time: Fri Dec 02 12:44:42 CST 2016

Total time taken to generate the page: 0.09909 seconds