alter table oracle
snippet in sql

alter table oracle

user9921

ALTER TABLE tablename MODIFY columnname varchar2(100)

PL SQL MODIFY COLUMN NME

user8808

ALTER TABLE table_name
  RENAME COLUMN old_name TO new_name;