The BINARY_INTEGER datatype is identical to PLS_INTEGER. You use the PLS_INTEGER datatype to store signed integers. Its magnitude range is -2147483648 to 2147483647, represented in 32 bits. PLS_INTEGER values require less storage than NUMBER values and NUMBER subtypes. Also, PLS_INTEGER operations use hardware arithmetic, so they are faster than NUMBER operations, which use library arithmetic. For efficiency, use PLS_INTEGER for all calculations that fall within its magnitude range. For calculations outside the range of PLS_INTEGER, you can use the INTEGER datatype. binary_integer对应有符号的整数.number可以包含小数点,你可以认为binary_integer是number的子集. number(precision,scale),对于binary_integer,不考虑大小取值,他相当于number(precision,0)
You use the PLS_INTEGER datatype to store signed integers. Its magnitude range is -2147483648 to 2147483647, represented in 32 bits. PLS_INTEGER values require less storage than NUMBER values and NUMBER subtypes. Also, PLS_INTEGER operations use hardware arithmetic, so they are faster than NUMBER operations, which use library arithmetic. For efficiency, use PLS_INTEGER for all calculations that fall within its magnitude range. For calculations outside the range of PLS_INTEGER, you can use the INTEGER datatype.
binary_integer对应有符号的整数.number可以包含小数点,你可以认为binary_integer是number的子集.
number(precision,scale),对于binary_integer,不考虑大小取值,他相当于number(precision,0)
binary_integer 是number的子集吧
binary_integer 一般用于数组(联合数组)的下标不过现在大部分数值型的数据都差不多用number