IMHO, bulk collect is the best...

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



-- 
Best regards,
Sofhal Jamil
PT Datainfo Milenium Perkasa
Jl. Mundu Raya No. 2, Jati, Pulo Gadung
Jakarta Timur, 13220
Telp./Faks (021) 489-0705
http://sofhaljamil.com

Kirim email ke