How can we use Forall operation for following progm ...
If we use for it takes times ..I wanted to use bulk bind for faster execution ,,
Can u plz suggest how and where to use forall operator in this following progm
-
declare
-
vl_c_event_ct varchar2(1000);
-
vl_c_eventcd varchar2(1000);
-
vl_c_class Varchar2(1000);
-
Cursor c1 is select ACC_NUMBER, START_DATE ,END_DATE from am_test;
-
begin
-
for r1 in c1
-
loop
-
select sum( scs),evn_ID,TR_26
-
into vl_c_event_ct,vl_c_eventcd,vl_c_class from costt_test
-
where ACCOUNT_NUM in (select substr(acc_number,4,10) from am_test) and
-
to_char(CREATED_DTM,'ddmmyyyy') between (to_char(r1.START_DATE,'ddmmyyyy')) and(to_char(r1.END_DATE,'ddmmyyyy'))
-
group by EVENT_TYPE_ID,EVENT_ATTR_26 ;
-
dbms_output.put_line(vl_c_event_ct||' '||vl_c_eventcd||' '||vl_c_class);
-
insert into am_test2 values(vl_c_event_ct ,vl_c_eventcd ,vl_c_class ,r1.ACC_NUMBER ,r1.START_DATE ,r1.END_DATE );
-
end loop ;
-
end;
-
