ALTER TABLE tablename MODIFY columnname varchar2(100)
ALTER TABLE table_name RENAME COLUMN old_name TO new_name;