http://www.dba-oracle.com/t_alter_table_rename_column_syntax_example.htm
In Oracle9ir2, Oracle provides "alter table" syntax to rename data columns in-place in this form:
alter table
table_name
rename column
old_column_name
TO
new_column_name;
Here are some examples of Oracle "alter table" syntax to rename data columns.
alter table
cust_table
rename column
cust_sex
TO
cust_gender;