Thanx a lot Master Yoel...


----- Original Message ----
From: Yoel Susanto <[EMAIL PROTECTED]>
To: [email protected]
Sent: Tuesday, July 22, 2008 12:43:12 PM
Subject: Re: [indo-oracle] looping : cursor vs bulk collect..


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

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

    


      

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

Kirim email ke