Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: 'alter table' add column question

Re: 'alter table' add column question

From: Rolf Hauck <Rolf.Hauck_at_datenrevision.de>
Date: 1998/09/29
Message-ID: <36107EE2.8161BB68@datenrevision.de>#1/1

In general, SQL doesn't have a concept of "positions" of columns. The order of columns depends on your Select statement. You could create a View on your Table and explictly name the clumns in the order you want.

badstreetboy_at_my-dejanews.com wrote:
>
> I use 'alter table t1 add (newfield integer);' to add a new column to the
> table. The column 'newfield' is added as the last field of table: f1, f2,
> f3...newfield How can I control the position of the new column being added?
> Thanks.
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
Received on Tue Sep 29 1998 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US