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

Vadim Lejnin <lejnin_at_fors.ru> wrote in message news:36f8df87.0_at_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...
>
>
> --
>

p.s. I can use also 3 step:

SQL> rename test to test_table
SQL> create view test as select ....
SQL> desc  test

Best regards, Vadim Lejnin
Oracle and Unix Administrator company FORS Technical Support Department Received on Wed Mar 24 1999 - 07:29:12 CST