固定数组的定义及赋值
DECLARE TYPE ARRAYLIST IS VARRAY(100) OF VARCHAR(50);
MY_ARRAYLIST ARRAYLIST := ARRAYLIST('000015','000032');
BEGIN
for i in 1..MY_ARRAYLIST.count
loop
dbms_output.put_line(MY_ARRAYLIST(i));
end loop;
END;
参考链接oracle数组定义相关:
https://www.iteye.com/topic/580144