Rename Column Name in Oracle

Rename Column Name in Oracle

Suppose, we have the table as Stu as shown below:-

table

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:


Oracle Rename Column Example

Find that the name of the ADD_Date column has changed to admission.

Oracle Rename Column Example

Standard (Image)