HomeОбразованиеRelated VideosMore From: Subhroneel Ganguly

How to use BULK COLLECT to optimize PL SQL code.

12 ratings | 3824 views
An Online Training video to show how to use BULK COLLECT to optimize PL/SQL code.This oracle tutorial training video helps to understand performance tuning by using BULK COLLECT.
Html code for embedding videos on your blog
Text Comments (4)
Nasim Chaklader (2 years ago)
HI Gangulycan I use FORALL statement inside the LOOP?what I mean, Instead of using DBMS_OUTPUT to display, I want to INSERT by using FORALL.
Subhroneel Ganguly (2 years ago)
+Nasim Chaklader [email protected]
Nasim Chaklader (2 years ago)
Hi Ganguly Thanks for your reply. can you give you email, so I can email you, I have to upgrade my code into forall and bulk collect. Your suggestion will be highly appreciated Thanks Naism
Subhroneel Ganguly (2 years ago)
I do not understand your question. FORALL itself is an iterator. You can use it instead of FOR , WHILE loop, loop fetch. It runs more faster. You can write insert statement inside FORALL loop.

Would you like to comment?

Join YouTube for a free account, or sign in if you are already a member.