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...


> 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

>

>

>

>

>