Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Alter column so column comes in the middle of column list...
Try to find third party DBA products.
tim.mcconechy_at_runtime.dk 撰寫於文章 <7dal2b$ttq$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)
>
>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...
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Wed Mar 24 1999 - 08:46:57 CST