how to change the length of a column in oracle code example Example: alter table column size oracle ALTER TABLE tablename MODIFY fieldname VARCHAR2(100);