change column name sql 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;
alter table sales rename column order_date to date_of_order;
ALTER TABLE table_name
RENAME COLUMN old_name TO new_name;