i would imagine there are some quick reads on asktom that would suffice.
On 11/16/05, Yasin Baskan <yasbs_at_kocbank.com.tr> wrote:
>
> Hi,
>
> Developers in my company tend to use cursors and loops to fetch data and
> process them in plsql. Either they are not aware of the bulk collect feature
> or they do not prefer it i do not know why.
>
> I have advised to modify some programs to use bulk collects to decrease
> the number of logical reads and we had huge performance improvements. Also
> they tend to fetch rows from cursors and process them, instead of using a
> simple select statement to do the same job. I am trying to change this
> coding behaviour also, but that's another story.
>
> I have prepared a small document that explains the bulk collect feature
> simply. If anyone is interested in the subject and also have time, i would
> be pleased if you can review it and share your opinions and corrections with
> me. Before i send it to the developers i would like it to be reviewed.
>
> So, if anybody is interested can you send me an email so i can send you
> the document for review.
>
> Thanks.
>
> <http://www.spreadfirefox.com/?q=affiliates&id=105360&t=70>
>
>
>
> Bu mesaj ve onunla iletilen tum ekler gonderildigi kisi ya da kuruma ozel
> ve Bankalar Kanunu geregince, gizlilik yukumlulugu tasiyor olabilir. Bu
> mesaj, hicbir sekilde, herhangi bir amac icin cogaltilamaz, yayinlanamaz ve
> para karsiligi satilamaz; mesajin yetkili alicisi veya alicisina iletmekten
> sorumlu kisi degilseniz, mesaj icerigini ya da eklerini kopyalamayiniz,
> yayinlamayiniz, baska kisilere yonlendirmeyiniz ve mesaji gonderen kisiyi
> derhal uyararak bu mesaji siliniz. Bu mesajin iceriginde ya da eklerinde yer
> alan bilgilerin dogrulugu, butunlugu ve guncelligi Bankamiz tarafindan
> garanti edilmemektedir ve bilinen viruslere karsi kontrolleri yapilmis
> olarak yollanan mesajin sisteminizde yaratabilecegi zararlardan Bankamiz
> sorumlu tutulamaz.
> This message and the files attached to it are under the privacy liability
> in accordance with the Banking Law and confidential to the use of the
> individual or entity to whom they are addressed. This message cannot be
> copied, disclosed or sold monetary consideration for any purpose. If you are
> not the intended recipient of this message, you should not copy, distribute,
> disclose or forward the information that exists in the content and in the
> attachments of this message; please notify the sender immediately and delete
> all copies of this message. Our Bank does not warrant the accuracy,
> integrity and currency of the information transmitted with this message.
> This message has been detected for all known computer viruses thence our
> Bank is not liable for the occurrence of any system corruption caused by
> this message
>
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Nov 16 2005 - 06:36:15 CST
