Index的数据类型它可以是0到声明的最大值,是个整形数值。索引为PLS_INTEGER的
一个关联数组,示例如下:
CREATE OR REPLACE PROCEDURE P_5_10 AS
TYPE sum_multiples IS TABLE OF PLS_INTEGER INDEX BY PLS_INTEGER;
m PLS_INTEGER := 3;
s sum_multiples;
BEGIN
FOR i IN 1..m LOOP
s(i) :=100+i; -- sum of multiples
END LOOP;
DBMS_OUTPUT.PUT_LINE (s(1));
DBMS_OUTPUT.PUT_LINE (s(2));
GBase 8s PL/SQL手册
南大通用数据技术股份有限公司
- 65 -
DBMS_OUTPUT.PUT_LINE (s(3));
END;