ORACLE - ALTER TABLE: Rename Table

Syntax:

ALTER TABLE table_name
RENAME TO new_table_name;

Example:
ALTER TABLE emp
RENAME TO emp_records;

This will change the table name from 'emp' to emp_record.