Alter table Modify

This command is used to alter table existing data type.By giving this command we can change the parameter of  an  table.

ALTER TABLE table_name  MODIFY column_name column_type;

alter table emp modify id number(20);