HomeОбразованиеRelated VideosMore From: Manish Sharma

PL/SQL tutorial 74: PL/SQL Bulk Collect Clause with FETCH-INTO statement of an explicit cursor

297 ratings | 12317 views
RebellionRider.com presents a PL/SQL tutorial on how to use PL/SQL Bulk Collect with Fetch-Into statement of an explicit cursor in Oracle Database. Watch and learn how to enhance query performance with Bulk Collect in Oracle Database by Manish Sharma. ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog: http://bit.ly/bulk-collect-3 Previous Tutorial ► Introduction to Bulk Collect: https://youtu.be/HPVzFBluM_Q ► Explicit Cursor: https://youtu.be/3q7dW_d2KVc ► Simple Loop: https://youtu.be/AFx6QYcY1CU ► The script on GIT: https://github.com/RebellionRider/pl-sql-tut-74.git ------------------------------------------------------------------------- ►Make sure you SUBSCRIBE and be the 1st one to see my videos! ------------------------------------------------------------------------- ►►►Find me on Social Media◄◄◄ Follow What I am up to as it happens on https://twitter.com/rebellionrider http://instagram.com/rebellionrider https://plus.google.com/+Rebellionrider http://in.linkedin.com/in/mannbhardwaj/ ___Facebook Official Page of Manish Sharma___ https://www.facebook.com/TheRebellionRider/ ___Facebook Official Page of RebellionRider.com___ https://www.facebook.com/RebellionRider.official/ For E-mail address please check the About section Please please LIKE and SHARE my videos it makes me happy. Thanks for liking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com ♥ I LOVE ALL MY VIEWERS AND SUBSCRIBERS
Html code for embedding videos on your blog
Text Comments (15)
Danilo Oliveira (16 days ago)
In this exemple you used the nested table, Why when we used bulk collection it's not necessary to use the method extend?
nalinakshee panda (1 month ago)
Git page is not available. 404 found error is coming.
Sinisa Zec (4 months ago)
I don't understand why did you put FETCH BULK COLLECT inside loop. And I don't understand why you used EXIT WHEN fName.COUNT = 0; instead of EXIT WHEN exp_cur.%NOTFOUND...? fName.COUNT should never be zero unless we delete all the members, or am I totally wrong? Something is not quite correct here, or at least not quite clear. Once said that, I must also say that I like your videos!
rahul nigam (15 days ago)
yes i am thinking the same but i am not sure if i am correct.
Anil Mohanty (11 months ago)
Manish using 1..collection. Count gives all the record on the same way can I use collection. First.. Collection. Last to get all the record if yes what is the diff
Akash Dey (1 year ago)
HI Mahish, Thanks for your nice tutorial. But is that required to create the outer loop ?? As per my understanding, if we are using bulk collect then automatically entire set of rows will be fetched( bulk collected) into PLSQL table variable ? Please correct me
Nikhil Khare (1 year ago)
Why did you put Fetch statment inside the LOOP??? I kept it outside of loop, means w/o the loop, still working the same as when kept inside.
Ganesh Gupta (1 year ago)
one silly clarification needed, since bulk collect will combine all the records in single chunk only, so why you have used Loop here. that first loop will always be execute only 1 time. ryte?
Abhishek Barnwal (5 months ago)
Hi, your doubt is valid. Here loop won't be needed. Just 3 steps... open... Fetch.... Close...
vasi sultan (6 months ago)
Hey Ganesh,Did you find the answer of your question. I was also thinking the same question but still am not able to find the correct answer.please can you help?
Laxminath Dewangan (1 year ago)
Hi Manish sir, For printing when I write the 'FOR' statement after closing the cursor , its getting compiled but no output is coming . could you plz help me to understand. Thanks
Grs Raja (1 year ago)
Great Sir... could you please provide a video for disadvantage of bulk collect
Shashank Dasaniya (1 year ago)
Hello sir ...where we can find videos later than no. 74?
siddharth chaudhary (1 year ago)
sir, can you please tell how much videos are left for uploading so we can have a better idea of the things remaining. thank you, videos are awesome.
Maha Sridhar (1 year ago)
Thank you so much for the videos. I am starting my career as database developer and I find your videos highly useful.

Would you like to comment?

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