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

No need to be snide. The OP is talking about the alter table wizard 
remember...it's possible for the toad developers to have added some 
magic code behind the window. For instance they could have coded the 
window to do a create table foo2 as select columns in correct order from 
foo1 and then drop foo1, and rename foo2 to foo1.

Still one of Oracle's basic points is that when working with relational 
databases, unlike spreadsheets like excel,
column order in the table doesn't matter to the "computer" and shouldn't 
matter to the developer.

"select *" is evil.

Column order in indexes are a separate matter entirely. There the order 
is important, and whole books have been written on the subject.


On 05/24/2012 01:18 PM, SCHROEDER, NATHAN E (AG/1000) wrote:
>
> ... or I suppose you could drop all the columns after the intended 
> insertion point, add the new column, then add all the other columns 
> back. And then try to remember where you saved the data from the 
> dropped columns -- what? I was supposed to save that?
>
> Nate Schroeder
>
> Enterprise Services - Data Management Team
>
> Monsanto Company
>
> 800 N. Lindbergh Blvd. B2SB - Saint Louis, MO - 63167
>
> 314-694-2592
>
> *From:*[email protected] [mailto:[email protected]] *On Behalf 
> Of *John Dorlon
> *Sent:* Thursday, May 24, 2012 12:08 PM
> *To:* [email protected]
> *Subject:* [toad] RE: Is it possible to insert column between existing 
> columns using the alter table wizard?
>
> No.  Oracle doesn't allow that.  If you want to do that, you'll need 
> to rebuild the table.
>
> *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.
>
> This e-mail message may contain privileged and/or confidential 
> information, and is intended to be received only by persons entitled
> to receive such information. If you have received this e-mail in 
> error, please notify the sender immediately. Please delete it and
> all attachments from any servers, hard drives or any other media. 
> Other use of this e-mail by you is strictly prohibited.
>
> All e-mails and attachments sent and received are subject to 
> monitoring, reading and archival by Monsanto, including its
> subsidiaries. The recipient of this e-mail is solely responsible for 
> checking for the presence of "Viruses" or other "Malware".
> Monsanto, along with its subsidiaries, accepts no liability for any 
> damage caused by any such code transmitted by or accompanying
> this e-mail or any attachment.
>
>
> The information contained in this email may be subject to the export 
> control laws and regulations of the United States, potentially
> including but not limited to the Export Administration Regulations 
> (EAR) and sanctions regulations issued by the U.S. Department of
> Treasury, Office of Foreign Asset Controls (OFAC).  As a recipient of 
> this information you are obligated to comply with all
> applicable U.S. export laws and regulations.
>
>