Re: RE-NAMING A COL.

Hi,

thanks for not reading my original posting, before giving me this gem.

Pavel Drs <pavel.drs_at_anfdata.cz> wrote:

> 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
> >
> >
> >
> >
> >
Received on Tue Apr 18 2000 - 00:00:00 CDT