atler table name in plsql code example

Example 1: RENAME table pl sql

ALTER TABLE old_table_name
  RENAME TO new_table_name;

Example 2: alter table name sql

-- Microsoft SQL style
EXEC sp_rename 'TableOldName', 'TableNewName';