forall BULK COLLECT 从表里面直接拉数据

1、通过BULK COLLECT 批量将表里面的数据抽出

2、通过forall批量插入新表中

DECLARE   
   TYPE table_forall IS TABLE OF test_forall%ROWTYPE;   
   v_table table_forall;   
BEGIN   
     SELECT mub.user_id,mub.user_name   
         BULK COLLECT INTO v_table   
     FROM mag_user_basic mub   
          WHERE mub.user_id BETWEEN 10000 AND 10100;   
     FORALL idx IN 1..v_table.COUNT   
            INSERT INTO test_forall VALUES v_table(idx);   
     COMMIT ;   
  
EXCEPTION   
     WHEN OTHERS THEN   
         ROLLBACK ;   
END ;