Re: Alter column so column comes in the middle of column list...

From: Vadim Lejnin <lejnin_at_fors.ru>
Date: Wed, 24 Mar 1999 15:51:45 +0300
Message-ID: <36f8df87.0@news.telekom.ru>

<tim.mcconechy_at_runtime.dk> wrote in message news:7dal1s$ttn$1_at_nnrp1.dejanews.com...
> I don't know how to explain this but I'll try..
>
> Say I have a table
> CREATE TABLE TEST ( col1 number2,col2 varchar2(20));
>
> If I add a column using..
> ALTER TABLE TEST ADD col1_5 number;
>
> Then my table looks like:
> SQL> desc test
> Name Null? Type
> ------------------------------- -------- ----
> COL1 NUMBER
> COL2 VARCHAR2(20)
> COL1_5 NUMBER
>
>
> I want it to look like:
> SQL> desc test
> Name Null? Type
> ------------------------------- -------- ----
> COL1 NUMBER
> COL1_5 NUMBER
> COL2 VARCHAR2(20)
create view test1 as select col1,col1_5,col2 from test;

desc test1

Name                            Null?    Type
------------------------------- -------- ----
COL1                                     NUMBER
COL1_5                                   NUMBER

COL2
> Is there someway to alter table so I can do this...
>
> I know I can drop and recreate but don't want to!!!!
>
> thanks for your help...

--

Best regards, Vadim Lejnin

Oracle and Unix Administrator company FORS Technical Support Department Received on Wed Mar 24 1999 - 06:51:45 CST