change data type of a column in oracle code example Example: alter table oracle ALTER TABLE tablename MODIFY columnname varchar2(100)