Re: 'alter table' add column question

From: Winnie Liu <oracle_dba_at_zdnetmail.com>
Date: 1998/09/29
Message-ID: <6us55v$rk0@sjx-ixn4.ix.netcom.com>#1/1

Oracle don't really care about the position of the columns in a table. BTW, why do you care? You can always select in whatever order you want from the table and insert in whatever order you want too!

Winnie

badstreetboy_at_my-dejanews.com wrote in message <6up58l$ea2$1_at_nnrp1.dejanews.com>...
>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