Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Renaming a column in Oracle 7.3.3

Re: Renaming a column in Oracle 7.3.3

From: Grillix <grillix_at_grillix.com>
Date: Wed, 07 Jul 1999 23:20:52 GMT
Message-ID: <3783e082.1961483@news.tcp.co.uk>


On Mon, 5 Jul 1999 11:44:34 +0100, "Cecília Oliveira" <ceciliaoliveira_at_cmvm.pt> wrote:

>No you can't rename a column in Oracle 7.3.3.
>
>
>VBlanton wrote in message <19990702001611.23766.00005452_at_ng-cf1.aol.com>...
>>Is it possible to rename a column without dropping and recreating the
>entire
>>table?
>>Is there a way of using the ALTER statement for this purpose?
>>Any ideas?
>>
>>Thanks
>>vblanton_at_aol.com
>

It should have been added years ago. My DBA friend wrote scripts to it, so why can't Oracle make it part of the syntax?

Grillix Received on Wed Jul 07 1999 - 18:20:52 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US