ALTER TABLE tablename MODIFY columnname varchar2(100)
ALTER TABLE table_name ADD column_name column_definition;