Oracle存储过程数组的使用方法

declare-- Local variables hereTYPE v_ar IS VARRAY(8) OF INTEGER;my_array v_ar := v_ar(1,2,3,4,5,6,7,8);BEGINFOR i IN 1..my_array.COUNT LOOPdbms_output.put_line(my_arr...

JLucky123

7589人浏览 · 2018-10-15 22:56:01

JLucky123 · 2018-10-15 22:56:01 发布



declare 
  -- Local variables here
  TYPE v_ar IS VARRAY(8) OF INTEGER;
  my_array v_ar := v_ar(1,2,3,4,5,6,7,8);
BEGIN 
        FOR i IN 1..my_array.COUNT LOOP
          dbms_output.put_line(my_array(i));
    END LOOP;
end;

输出日志应为：
1
2
3
4
5
6
7
8