change column name oracle code example

Example 1: rename column ORACLE

alter table sales rename column order_date to date_of_order;

Example 2: PL SQL MODIFY COLUMN NME

ALTER TABLE table_name
  RENAME COLUMN old_name TO new_name;