Re: renaming a cloumn

Thomas Kyte <tkyte_at_us.oracle.com> wrote in message news:<9v694g02bd6_at_drn.newsguy.com>...
> 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
> >> >
> >> >
> >

Try this if u want.

sqlplus>connect sys/*******
sqlplus>update col$ set name='NEW_COLUMN_NAME' where obj#=(select obj# from obj$ where name='UR_TABLE_NAME' and owner#=(select user# from user$ where name='UR_ACCOUNT') ) and name='OLD_COLUMN_NAME';

sqlplus>commit; 
sqlplus>alter system flush shared_pool; 
sqlplus>desc ur_account.ur_table_name