ORACLE BULK PROCESSING WITH BULK COLLECT AND FORALL

DECLARE
  l_names  DBMS_UTILITY.maxname_array;
BEGIN
  l_names (1) := ‘Strawberry’;
  l_names (10) := ‘Blackberry’;
  l_names (2) := ‘Raspberry’;

  DECLARE
    indx  PLS_INTEGER := l_names.FIRST;
  BEGIN

    WHILE (indx IS NOT NULL)
    LOOP
      DBMS_OUTPUT.put_line (l_names (indx));
      indx := l_names.NEXT (indx);
    END LOOP;
  END;
END;
/

Leia mais sobre Oracle BULK COLLECT Mais