ORACLE TYPE INTEGER_ARRAY VERSUS NUMBER_ARRAY

Posted on Edited on In Views: Disqus: Symbols count in article: 461 Reading time ≈ 1 mins.

ORACLE TYPE INTEGER_ARRAY VERSUS NUMBER_ARRAY

這篇介紹ORACLE TYPE INTEGER_ARRAY VERSUS NUMBER_ARRAY。

Definition

TYPE INTEGER_ARRAY IS TABLE OF BINARY_INTEGER INDEX BY BINARY_INTEGER;
TYPE NUMBER_ARRAY IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;

NUMBER : Numeric data, with a precision of p and scale of s. Precision p ranges from 1 to 38,
and scale ranges from -84 to 127.

INTEGER : Signed integer. Older , slower version of PLS_INTEGER. From -2,147,483,647 to
2,147,483,647.

一般用途數字符合NUMBER大小選擇使用NUMBER_ARRAY即可，有特殊數字需求可選擇INTEGER_ARRAY。