We use following sytax to rename the column of a table

Oracle syntax :

ALTER TABLE table_name
RENAME COLUMN old_column_name TO new_column_name;

MySql syntax :

ALTER TABLE table_name
Change old_column_name  new_column_name [Data Type];

Oracle example :

ALTER TABLE student
RENAME COLUMN Student_mob_no TO mob_no;

MySql example :

ALTER TABLE student
Change Student_mob_no  mob_no;