Avoid declaring NUMBER variables or subtypes with no precision.
If you do not specify precision NUMBER is defaulted to 38 or the maximum supported by your system, whichever is less. You may well need all this precision, but if you know you do not, you should specify whatever matches your needs.
Try to use PLS_INTEGER instead of NUMBER for arithmetic operations with integer values (no decimal point).
PLS_INTEGER has a length of -2,147,484,648 to 2,147,484,648 , on a 32 bit system.
There are many reasons to use PLS_INTEGER instead of NUMBER:
With Oracle 11g and above, the new data type SIMPLE_INTEGER has been introduced. It is a sub-type of PLS_INTEGER and covers the same range. The basic difference is that
© 2020 Digcode.com. All rights reserved.