Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: RE-NAMING A COL.
SQL> create table dummy (a number, b number);
Table created.
real: 721
SQL> alter table dummy drop column a;
Table altered.
real: 1602
SQL> desc dummy;
Name Null? Type ------------------------------- -------- ---- B NUMBER
SQL>
-- pavel.drs_at_anfdata.cz Steve A <steve_at_micromark.com.cn> pí¹e v diskusním pøíspìvku:1e98dp4.1j4xzh2rxwp54N%steve_at_micromark.com.cn...Received on Mon Apr 17 2000 - 00:00:00 CDT
> Hi,
> is it possible to rename a col in oracle 8.1.5
>
> I have a table with some dead col's in, and would like to re-use them.
>
> I cannot just drop the col, because I use a select into array in my
> client application,so if I drop the col, then all my arrays will go out
> of sync, I also like my col names to make sense.
>
>
>
> It seems such a simple process, but i cannot find anything in the docs
> about it.
>
> steve
>
>
>
>
>