Re: renaming a cloumn

In article <3C169496.CD6C5F63_at_web.de>, Holger says...
>
>Hi,
>
>this is not correct. I think since 8.1.7 it is possible to rename columns.
>I have done it a few weeks ago, but can't remember the syntax.
>If you have installed the help you should a have a look at the parameters for
>"alter table modify column". I think it was "move" but I'm not sure.
>

nope, you cannot rename a column. you did something else.

you can 'move' a table, you cannot rename a column.

>Hope this helps,
> Holger
>
>Sue Wi-Afedzi schrieb:
>
>> You can't rename a column, but you can add a new column with the new name,
>> (alter table add ...), populate it with the values of the first column, then
>> drop the first column (alter table drop column <column name>). The
>> database must be 8i or higher and the owner of the table cannot be SYS.
>>
>> Hope that helps.
>>
>> Sue
>> "Najm Hashmi" <najmh_at_videotron.ca> wrote in message
>> news:wtjR7.18657$2F2.1189458_at_weber.videotron.net...
>> > Hi All,
>> > What is the correct syntax to rename a column in a table using alter table
>> > command.
>> > Thanks in advance.
>> > Regards, Najm
>> >
>> >
>

--
Thomas Kyte (tkyte@us.oracle.com)             http://asktom.oracle.com/ 
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp