访问 W_PUNISH 的成员时,你可以使用整型索引,如: declare type W_PUNISH is record(id number(4),val varchar2(10)); TYPE TAB_TYPE IS TABLE OF W_PUNISH%ROWTYPE INDEX BY BINARY_INTEGER; mytable TAB_TYPE; begin mytable(1).id := 1; mytable(1).val := 'one'; ....
属于集合的一种,index_by表,分别与嵌套表,数组称为集合 用法与后两者有所不同,使用不用初始化,比较方便易用 INDEX BY BINARY_INTEGER --是关键字数组: type t_varr is varray(10) of varchar2(20); 嵌套表: type t_table is table of number;
declare
type W_PUNISH is record(id number(4),val varchar2(10));
TYPE TAB_TYPE IS TABLE OF W_PUNISH%ROWTYPE
INDEX BY BINARY_INTEGER;
mytable TAB_TYPE;
begin
mytable(1).id := 1;
mytable(1).val := 'one';
....
用法与后两者有所不同,使用不用初始化,比较方便易用
INDEX BY BINARY_INTEGER --是关键字数组:
type t_varr is varray(10) of varchar2(20);
嵌套表:
type t_table is table of number;