-- Created on 2013-9-16 by ADMINISTRATOR
declare
-- Local variables here
i integer;
TYPE tbl_test IS TABLE OF NUMBER INDEX BY PLS_INTEGER;
v_tbl_test tbl_test;
begin
-- Test statements here
v_tbl_test(1) := 1;
v_tbl_test(2) := 2;
v_tbl_test.delete(1);
FOR i IN v_tbl_test.first .. v_tbl_test.last LOOP
dbms_output.put_line(v_tbl_test(i));
END LOOP;
end;
declare
-- Local variables here
i integer;
TYPE tbl_test IS TABLE OF NUMBER INDEX BY PLS_INTEGER;
v_tbl_test tbl_test;
begin
-- Test statements here
v_tbl_test(1) := 1;
v_tbl_test(2) := 2;
v_tbl_test.delete(1);
FOR i IN v_tbl_test.first .. v_tbl_test.last LOOP
dbms_output.put_line(v_tbl_test(i));
END LOOP;
end;
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/13387766/viewspace-772743/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/13387766/viewspace-772743/