Oracle PL/SQL Einzel-Tipp ansehen

Bulk Cursor mit LIMIT Klausel

Tipp 31

DECLARE CURSOR
big_cur IS
SELECT object_id FROM scott.big_tab;
TYPE big_tab_type IS TABLE OF scott.big_tab.object_id%TYPE;
mybig_tab big_tab_type; summe NUMBER:=0;
teil_summe NUMBER:=0;
BEGIN OPEN big_cur;
LOOP FETCH big_cur BULK COLLECT INTO mybig_tab LIMIT 100;
FOR i IN 1.. mybig_tab.count LOOP
summe:=summe+mybig_tab(i);
END LOOP;
EXIT WHEN big_cur%notfound;
END LOOP;
CLOSE big_cur;
END;
/