ORACLE开发之数组用法

ORACLE开发之数组用法

–声明类型
TYPE NF2719_TYPE IS TABLE OF VARCHAR2(100) INDEX BY BINARY_INTEGER;
–声明变量
v_lines NF2719_TYPE;
v_first_index NUMBER;
–初始化
v_lines.delete;
–赋值
v_lines(1) := ‘第一行数据’;
–索引是否存在
IF v_lines.exists(2) THEN
DBMS_OUTPUT.PUT_LINE(‘索引2存在’);
END IF;
– 数组遍历
v_first_index := v_lines.first;
WHILE v_first_index IS NOT NULL LOOP
dbms_output.put_line(v_lines(v_first_index));
v_first_index := v_lines.next(v_first_index);
END LOOP;