RE: Is it possible to insert column between existing columns using the alter table wizard?

I think we all know it's not important, but it sure is nice to have columns in a meaningful order.  So why not put them where you want them?

From: [email protected] [mailto:[email protected]] On Behalf Of Bert Scalzo
Sent: Thursday, May 24, 2012 12:34 PM
To: [email protected]
Subject: [toad] RE: Is it possible to insert column between existing columns using the alter table wizard?


One  more thing to consider - regular oracle does block level IO so generally you get the whole row hence column order not important. Exadata is different and only the columns asked for come back - so again column order not an issue ....

From: [email protected]<mailto:[email protected]> [mailto:[email protected]]<mailto:[mailto:[email protected]]> On Behalf Of Bert Scalzo
Sent: Thursday, May 24, 2012 12:29 PM
To: [email protected]<mailto:[email protected]>
Subject: [toad] RE: Is it possible to insert column between existing columns using the alter table wizard?


Is there any special reason why the order of the columns is important? Because according to relational theory - this does not matter. And while it used to matter in pre-8i days, the order does not really make much difference anymore - except maybe if you fall into one or two very rare scenarios ....

So why???


From: [email protected]<mailto:[email protected]> [mailto:[email protected]]<mailto:[mailto:[email protected]]> On Behalf Of Joseph E Meyers I
Sent: Thursday, May 24, 2012 12:06 PM
To: [email protected]<mailto:[email protected]>
Subject: [toad] Is it possible to insert column between existing columns using the alter table wizard?



[cid:[email protected]]
Is it possible to insert column(s) between existing columns using the alter table wizard?

I would like to avoid dropping the table and recreating if possible.

[Description: Description: Description: C:\Users\meyers\Desktop\CCC-Logo-Email-Signature.png]

Joseph E. Meyers I<http://josephmeyers.com/>
Banner Functional Support Specialist
Adjunct Lecturer
Cayuga Community College
197 Franklin Street T331
Auburn, NY 13021
AIM<http://aim.com/>/EMAIL: [email protected]<mailto:[email protected]>
(phone) 315-255-1792 x2270
Think Big. Start Smart.



01001010 01101111 01110011 01100101 01110000 01101000 00100000 01000101 00101110 00100000 01001101 01100101 01111001 01100101 01110010 01110011 00100000 01001001

0101011101101000011110010010000001110111011011110111010101101100011001000010000001100001011011100111100101101111011011100110010100100000011101110110000101101110011101000010000001110100011011110010000001101010011101010110110101110000001000000110111101110101011101000010000001101111011001100010000001100001001000000111000001100101011100100110011001100101011000110111010001101100011110010010000001100111011011110110111101100100001000000110000101101001011100100111000001101100011000010110111001100101001111110000110100001010000011010000101001000010011001010110001101100001011101010111001101100101001000000111010001101000011001010010000001100100011011110110111101110010001000000111011101100001011100110010000001101111011100000110010101101110001000010010000100001101000010100000110100001010010000100110110001110101011001010010000001010011011010110110100101100101011100110010000100100001