需要先自定义类型,再定义变量,研究研究下面这个例子或许你就明白了: DECLARE
TYPE tab_numbers IS TABLE of NUMBER INDEX BY BINARY_INTEGER; -- 定义数组类型tab_numbers
v_arr tab_numbers := tab_numbers(); -- 定义并初始化一个数组变量v_arrBEGIN v_arr.extend(2); -- 数组扩展到2个元素
v_arr(1):=1;
v_arr(2):=2;
FOR i IN 1..v_arr.count LOOP
DBMS_OUTPUT.PUT_LINE(v_arr(i));
END LOOP;END;
TYPE tab_numbers IS TABLE of NUMBER INDEX BY BINARY_INTEGER; -- 定义数组类型tab_numbers
v_arr tab_numbers := tab_numbers(); -- 定义并初始化一个数组变量v_arrBEGIN v_arr.extend(2); -- 数组扩展到2个元素
v_arr(1):=1;
v_arr(2):=2;
FOR i IN 1..v_arr.count LOOP
DBMS_OUTPUT.PUT_LINE(v_arr(i));
END LOOP;END;
TYPE tab_numbers IS TABLE of NUMBER INDEX BY BINARY_INTEGER; -- 定义数组类型tab_numbers这是一行,排版不好