CREATE TABLE PT_PRO 
(
  ID NUMBER GENERATED ALWAYS AS IDENTITY INCREMENT BY 1 MAXVALUE 9999999999999999999999999999 MINVALUE 1 CACHE 20 ORDER NOT NULL 
, DATE_ID NUMBER NOT NULL 
, GROUP_ID NUMBER 
, TYPE_ID NUMBER 
, CODE NUMBER 
}

declare 
type t_date_id is table of pt_pro.date_id%type index by pls_integer; 
type t_group_id is table of pt_pro.group_id%type index by pls_integer; 
type t_type_id is table of pt_pro.type_id%type index by pls_integer; 
type t_code is table of pt_pro.code%type index by pls_integer; 
p_ date_id t_date_id; 
p_ group_id t_group_id; 
p_ type_id t_type_id; 
p_code t_code; "
begin 
p_ date_id := :date_id; 
p_ group_id := : group_id ; 
p_ type_id := : type_id; 
p_code := :code; 
forall i in p_date.first..p_date_id.last 
insert into pt_pro (date_id,group_id,type _id,code) 
values (p_date_id(i), p_group_id(i) , p_type_id(i), p_code(i)); 

SQL ID: 8vfg94vf8m7m9 Plan Hash: 523367902

INSERT INTO PT_PRO(DATE_ID,GROUP_ID,TYPE_ID,
  CODE) 
VALUES
 (:B1 , :B2 , :B3 , :B4 )


call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        0      0.00       0.00          0          0          0           0
Execute      1      0.65      12.92       7426        857     165865        8022
Fetch        0      0.00       0.00          0          0          0           0
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total        1      0.65      12.92       7426        857     165865        8022

Misses in library cache during parse: 0
Optimizer mode: ALL_ROWS
Parsing user id: 103  (D_USER)   (recursive depth: 1)

Rows     Execution Plan
-------  ---------------------------------------------------
      0  INSERT STATEMENT   MODE: ALL_ROWS
      0   LOAD TABLE CONVENTIONAL OF 'PT_PRO'
      0    SEQUENCE OF 'ISEQ$$_108127' (SEQUENCE)

  ID NUMBER GENERATED ALWAYS AS IDENTITY INCREMENT BY 1 MAXVALUE 9999999999999999999999999999 MINVALUE 1 CACHE 20 ORDER NOT NULL