oracle index by binary_integer,Oracle中index by binary_integer的作用

而如果没有这句话“index by binary_integer”，那就得要显示对初始化，且每插入一个元素到numbers类型的table中时，都需要先extend.

示例：

没加“index by binary_integer”时：

declare

type my_number_arr is table of number;

n    my_number_arr:= my_number_arr();

begin

n.extend;

n(1) := 2;

n.extend;

n(2) := 3;

for i in1 .. n.count loop

dbms_output.put_line(n(i));

end loop;

end;

输出：2，3

而如果加了“index by binary_integer”，代码如下写就可以达到上面的效果

declare

type my_number_arr is table of number index by binary_integer;

n my_number_arr;

begin

n(1) := 2;

n(2) := 3;

for i in1 .. n.count loop

dbms_output.put_line(n(i));

end loop;

end;