[indo-oracle] looping : cursor vs bulk collect..

[dony widiotomo]

Dear Oracle Master..

ada ga ya perbedaan performance antara menggunakan :

    cursor select...
    loop
    ..
    end loop
    
or using :

    select ... bulk collect into ... 
    for i in cur.first .. cur.last
    loop
    ...
    end loop

query yg digunakan adalah query yg sama..

thanx for all respons...


regards,
Dony Wid


      

[Non-text portions of this message have been removed]