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

Let me guess, your pick lists are generated automatically by selecting 
from dba_tab_columns? :)

On 05/24/2012 01:58 PM, Madvig, Daniel B wrote:
>
> I don't need it; you don't need it; Oracle doesn't need it; but my 
> reporters (and I) sure like it when related columns (say a code and 
> it's description/expansion) show up together in their pick lists. 
> Sometimes after testing for a while we realize that it would be nice 
> or necessary to have another column (inserted).
>
> Dan
>
> *Daniel B Madvig*
> /Campus Technologies/
>
> cid:[email protected] <http://nwc.edu/>
>
> 	
>
> *Northwestern College & Northwestern Media*
> _3003 Snelling Ave.
> St. Paul, MN 55113
> www.nwc.edu 
> <http://maps.yahoo.com/py/maps.py?Pyt=Tmap&addr=3003+Snelling+Ave.&csz=St.+Paul%2C+MN+55113&country=us>_
>
> 651.631.5323
>
> Knowledge is knowing that the tomato is a fruit; wisdom is /not/ 
> including it in a fruit salad. :-)
>
> *From:*[email protected] [mailto:[email protected]] *On Behalf 
> Of *Bert Scalzo
> *Sent:* Thursday, May 24, 2012 12:29 PM
> *To:* [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]] *On Behalf 
> Of *Joseph E Meyers I
> *Sent:* Thursday, May 24, 2012 12:06 PM
> *To:* [email protected]
> *Subject:* [toad] Is it possible to insert column between existing 
> columns using the alter table wizard?
>
> 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
>
> 010101110110100001111001001000000111011101101111011101010110110001100100001000000110000101101110011110010110111101101110011001010010000001110111011000010110111001110100001000000111010001101111001000000110101001110101011011010111000000100000011011110111010101110100001000000110111101100110001000000110000100100000011100000110010101110010011001100110010101100011011101000110110001111001001000000110011101101111011011110110010000100000011000010110100101110010011100000110110001100001011011100110010100111111000011010000101000001101000010100100001001100101011000110110000101110101011100110110010100100000011101000110100001100101001000000110010001101111011011110111001000100000011101110110000101110011001000000110111101110000011001010110111000100001001000010000110100001010000011010000101001000010011011
 0001110101011001010010000001010011011010110110100101100101011100110010000100100001
>
>