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.
To rename the existing table, use the following syntax:
Parameters:
oldtablename: The old table name that you want to rename.
newtablename: The new table name for the existing table.
Note:
In the above example, we rename the existing table "tblCustomerLoan" to "tblBankCustomer".