Bulk Collect 用法

DECLARE TYPE typ1 IS TABLE OF t.s_id%TYPE;

  v_typ typ1;

BEGIN

  SELECT s_id BULK COLLECT INTO v_typ from t where rownum<=100;

  FOR i IN 1..100 LOOP

    dbms_output.put_line(v_typ(i));

  END LOOP;

END;

/

 

DECLARE

  TYPE typ1 IS RECORD(rid INT ,rname VARCHAR2(20));

  TYPE tab1 IS TABLE OF typ1 INDEX BY BINARY_INTEGER;

  v_tab tab1;

BEGIN

  EXECUTE IMMEDIATE 'select s_id ,name from t where rownum<=100' BULK COLLECT INTO v_tab;

  FOR i IN 1..100 LOOP

    dbms_output.put_line(i||': '||v_tab(i).rid||' '||v_tab(i).rname);

  END LOOP;

END;

/