When there is data we can increase the size, we can not decrease the size but we cannot change the data type. Yes we can change the data type and size when there is no data
Why should I not commit after every record when updating a large table Committing after every record does not hurt but its much efficient to commit after a batch of records like 5000 - 7000.
Will the rows be inserted?