Suppose, we have the table as Stu as shown below:-
Syntax : Oracle Rename Column Using Alter
ALTER TABLE table_name
RENAME COLUMN old_name TO new_name;
Oracle Rename Column Example
ALTER TABLE Stu
RENAME COLUMN ADD_date TO admission;
Output:
Find that the name of the ADD_Date column has changed to admission.