Oracle Rename Table

Submitted by akshita.goel on Wed, 10/13/2021 - 10:10

Oracle also provide us with a feature to change the name of the pre-existing table.

Suppose we have a table, Stu:

Oracle Rename Table example

To change the name of this table from Stu to Student_Details, refer below:-

Syntax : Oracle Rename Table using Alter

ALTER TABLE Old_Name
 RENAME TO new_name;

ALTER TABLE Stu
 RENAME TO Student_Details;

Output:

Oracle Rename Table Name Example