number types sql

By default if you define something as NUMBER(3), the Oracle database will round the value, if possible to make the number fit, if the number cannot fit after rounding only then will it be rejected. If you enforce the NUMBER(3)