Oracle Tutorial

What is Oracle
SQL Keywords

Oracle Wildcards

Oracle Wildcards

Oracle Aliases

Oracle Aliases

MySQL Tutorial

MySQL Tutorial

PL/SQL Tutorial

PL/SQL Tutorial

Oracle Interview Questions

Oracle Interview Questions and Answers


Oracle Rename Table

Oracle Rename TABLE statement rename the existing table name. RENAME TABLE renames one or more tables. In addition to the tables, we can use the RENAME TABLE statement to rename views.

Oracle RENAME TABLE Syntax

To rename the existing table, use the following syntax:

Syntax

ALTER TABLE oldtablename RENAME TO newtablename;

Parameters:

oldtablename: The old table name that you want to rename.

newtablename: The new table name for the existing table.

Oracle RENAME TABLE examples

The following Oracle statement to rename existing table:

Example

ALTER TABLE tblCustomerLoan RENAME TO tblBankCustomer;

Note:

In the above example, we rename the existing table "tblCustomerLoan" to "tblBankCustomer".