Re: add a new column into the middle of an existing table
From: J.P. <jp_boileau_at_yahoo.com>
Date: 1 May 2002 05:57:22 -0700
Message-ID: <7e388bc3.0205010457.701efd87_at_posting.google.com>
Date: 1 May 2002 05:57:22 -0700
Message-ID: <7e388bc3.0205010457.701efd87_at_posting.google.com>
[Quoted] [Quoted] You gott'a stop thinking in non Relational-DB style...
The physical location of a column is totally irrelevant in a RDBMS.
JP
leiwang_q_at_hotmail.com (lei wang) wrote in message news:<af074b9c.0204301247.65da02f9_at_posting.google.com>...
> 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.
Received on Wed May 01 2002 - 14:57:22 CEST