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

If you aren't talking billions of rows, Toad makes it easier than that.
J

 

1.       Export the existing table to a spreadsheet file.

2.       Insert the new column into the spreadsheet.

3.       F4 describe the table.

a.       Click on the Script tab

b.      Click on the icon to "Copy script to an Editor Window".

c.       Insert the new column into the script.

d.      Execute the script.

4.       Use the Data Import Wizard to import the spreadsheet.

 

And there are probably six other ways to do it. J

 

Dan

 

Daniel B Madvig
Campus Technologies

 

  <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=S
t.+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
SCHROEDER, NATHAN E (AG/1000)
Sent: Thursday, May 24, 2012 12:19 PM
To: [email protected]
Subject: [toad] RE: Is it possible to insert column between existing
columns using the alter table wizard?

 

  

... 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.