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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Alter column so column comes in the middle of column list...

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

From: Vadim Lejnin <lejnin_at_fors.ru>
Date: Wed, 24 Mar 1999 16:29:12 +0300
Message-ID: <36f8e84c.0@news.telekom.ru>

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

Original text of this message

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