Re: Changing a column

From: <joseph_testa_at_aep.com>
Date: Tue, 21 Apr 1998 11:36:17 -0600
Message-ID: <6hihu2$vjd$1@nnrp1.dejanews.com>

I dont have a rename column package, but I wrote a drop column package. you can get it from http://www.oracle-dba.com

joe

In article <01bd6cf1$f948ae10$b8cd5997_at_sbaiz>, "Sbaiz" <pierluigi.sbaiz_at_elsag.it> wrote:
>
> Hi to all
> is there a way, in Oracle, to modifiy a column name without dropping the
> table
> maintaining its data. I know that others databases permit changing the name
> of
> the column or dropping a column, but Oracle not.
> It would be nice if Oracle can modify the column name or generate the
> scripts
> by itself, taking care of all the constraints.
>
> Thanks in advance.
> Pierluigi S.
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Tue Apr 21 1998 - 12:36:17 CDT