In this tutorial we are going to learn how to increase the size of a column . If we want to increase the size of a column , we have to use MODIFY with ALTER keyword . See the syntax below.
ALTER TABLE table_name MODIFY column_name datatype(size)
ALTER TABLE student MODIFY student_mob_no number(15)