Re: add a new column into the middle of an existing table
From: Daniel Morgan <dmorgan_at_exesolutions.com>
Date: Tue, 30 Apr 2002 22:09:47 GMT
Message-ID: <3CCF162A.70435A5E_at_exesolutions.com>
Date: Tue, 30 Apr 2002 22:09:47 GMT
Message-ID: <3CCF162A.70435A5E_at_exesolutions.com>
lei wang wrote:
> Is there an easy way to add a new column into the middle of an
> existing table? Seems to me that you have to create a new table and
> copies data from the old table. <Alter table add column> statement
> will only adds columns at the end of an existing table.
>
> I am using Oracle 8.1.7 EE on Solaris 2.7.
>
> Thanks.
[Quoted] [Quoted] You can not ... but it is equally true that the location of a column in [Quoted] a table is absolutely irrelevant. Stick it at the end and adjust your thinking.
Daniel Morgan Received on Wed May 01 2002 - 00:09:47 CEST