PLSQL collection 示例 之 varray

–在plsql developer里执行
CREATE OR REPLACE TYPE test_scalar_varray AS VARRAY(3) OF VARCHAR2(20);

–在plsql developer里执行
CREATE OR REPLACE FUNCTION test_filter_varray
( pv_scalar_varray IN OUT test_SCALAR_VARRAY)
RETURN BOOLEAN IS
lv_return BOOLEAN := FALSE;
BEGIN
pv_scalar_varray.TRIM(2);
–TRIM从集合末端开始删除一个元素
–TRIM(x)从集合末端开始删除x个元素
lv_return := TRUE;
RETURN lv_return;
END;

–在plsql developer里执行
DECLARE
lv_scalar_varray test_SCALAR_VARRAY := test_scalar_varray(‘Eine’,’Zwei’,’Drei’);
BEGIN
IF test_filter_varray(lv_scalar_varray) THEN
FOR i IN 1..lv_scalar_varray.LAST LOOP
dbms_output.put_line(‘varray’||’(‘||i||’):’||lv_scalar_varray(i));
END LOOP;
END IF;
END;