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;