Oracle 数组定义

固定数组的定义及赋值

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

posted @ 2020-12-04 10:45  CH|heyi  阅读(727)  评论(0编辑  收藏  举报