alter table modify column constraint in oracle code example
Example 1: alter table column size oracle
ALTER TABLE tablename MODIFY fieldname VARCHAR2(100);
Example 2: alter table oracle
ALTER TABLE tablename MODIFY columnname varchar2(100)
ALTER TABLE tablename MODIFY fieldname VARCHAR2(100);
ALTER TABLE tablename MODIFY columnname varchar2(100)