大家好:
我对于使用index by表,有如下疑问. 比如:
下面存储过程:
create or replace procedure IITest
is
TYPE numtab IS TABLE OF NUMBER (20) INDEX BY BINARY_INTEGER;
TYPE nametab IS TABLE OF VARCHAR2 (50) INDEX BY BINARY_INTEGER;
pnumsnumtab;
pnames nametab;
t1 NUMBER;
t2 NUMBER;
begin
select DBMS_UTILITY.get_timeINTO t1FROM DUAL;
FOR j IN 1 .. 1000000
LOOP
pnums (j) := j;
pnames (j):= 'Seq No. ' || TO_CHAR (j);
END LOOP;
FORALL i IN 1 .. 1000000
INSERT INTO ttest VALUES (pnums (i), pnums(i));
commit;