Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How insert new field in between?
Daniel Cloutier wrote:
>
> Hello everyone!
>
> Is there
> any solution to insert a field in between two existing fields or is it only
> possible to append a field to a table?
An 'alter table add (column)' will only add the column to the end - not in the middle or beginning. If you need to have the column added somewhere before the end of the table, you must drop, recreate, and reload the table with the new column in the position you want.
Cheers,
GC
Received on Thu Aug 23 2001 - 18:15:44 CDT