renaming column in 9i

[akwete]

Need the syntax if it is possible:

I want to rename NAME to INSTITUTION_NAME. This field is a NULL and currently has data in it. Working on 9i prod environment.

Thx

[Shestakov]

alter table TTTT add (INSTITUTION_NAME datatype);

update TTTTT set INSTITUTION_NAME=NAME;

alter table TTTT drop NAME;

[akwete]

Thanks Shestakov
it worked.

[akwete]

For your info, when dropping column in 8i or 9i add column
for example:

alter table TTTT drop column NAME;