Re: add a new column into the middle of an existing table

Daniel Morgan wrote:

>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.
>>
>
>You can not ... but it is equally true that the location of a column in
>a table is absolutely irrelevant. Stick it at the end and adjust your
>thinking.
>

I thought it was recommended to place nullable columns at the end of a table. I thought I read that somewhere. Something about saving space in the data block.

>
>
>Daniel Morgan
>
Received on Tue Apr 30 2002 - 19:53:59 CDT