Question: what is the difference between int and number in oracle?
Answer: Integer is only there for the sql standard ie deprecated by Oracle. You should use Number instead. ... When you define a NUMBER variable, you can specify its precision (p) and scale (s) so that it is sufficiently, but not unnecessarily, large. Precision is the number of significant digits.