forall operator

[orajit]

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;
 

[amitpatel66]

Orajit,

Please enclose your posted code in [code] tags (See How to Ask a Question).

This makes it easier for our Experts to read and understand it. Failing to do so creates extra work for the moderators, thus wasting resources, otherwise available to answer the members' questions.

Please use [code] tags in future.

MODERATOR

[amitpatel66]

Check here and here about BULK BIND and FORALL