rename table sql oracle code example

Example 1: rename column ORACLE

alter table sales rename column order_date to date_of_order;

Example 2: RENAME table pl sql

ALTER TABLE old_table_name
  RENAME TO new_table_name;