Oracle Rename Table

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;

Oracle Rename Table Name Example

ALTER TABLE Stu
 RENAME TO Student_Details;

Output:

Oracle Rename Table Name Example