this link should help you

http://venzi.wordpress.com/2007/09/27/bulk-collect-forall-vs-cursor-for-loop/

2008/7/22 dony widiotomo <[EMAIL PROTECTED]>:

>   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]
>
>  
>



-- 
Cheers,
Yoel Susanto

www.indo-oracletech.com


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

Kirim email ke