oracle中的数组或集合,Oracle数组集合类型index table2

Oracle数组集合类型index table2

Sql代码    www.2cto.com

-- Created on 2010/05/26 by NAN

declare

-- Local variables here

i integer;

TYPE t_test IS TABLE OF VARCHAR2(10 ) INDEX BY VARCHAR2 (10);

v_test t_test;

v_test2 t_test;

begin

-- Test statements here

FOR i IN 1 .. 10 LOOP

v_test(i) := i;

END LOOP;

v_test2 := v_test;

v_test2(11) := 'xxx';

FOR i IN 1 .. v_test2.count LOOP

dbms_output.put_line(v_test2(i));

END LOOP;

EXCEPTION

WHEN OTHERS THEN

dbms_output.put_line( sqlerrm);

end;