alter table column oracle code example

Example 1: rename column ORACLE

alter table sales rename column order_date to date_of_order;

Example 2: alter table column size oracle

ALTER TABLE tablename MODIFY fieldname VARCHAR2(100);

Example 3: alter table oracle

ALTER TABLE tablename MODIFY columnname varchar2(100)