modify datatype in oracle table code example Example: alter table oracle ALTER TABLE tablename MODIFY columnname varchar2(100)