Oracle alter table change column datatype. You can use the Oracle “alter table” syntax to change the data type for an existing column, as shown in this example:.
www.dba-oracle.com