4 PLSQL Performance Tuning | Bulk Collect | Part 3

• oracle plsql records a...
List of all Interview questions @ sivakacademy.b...
Oracle Interview questions and Answers at • oracle interview quest...
Oracle 18C New features at • Oracle 18C New Feature
Oracle 12C New features at • Oracle 12C New Feature...
Oracle PLSQL records and collections at • oracle plsql records a...

[@mohansarma4896]

super sir, it's my interview question bulk bind variable and bulk bind. Now I got confidence in the Bulk bind concept. Thank you, sir.

[@SivaAcademy]

Welcome bro

[@vivektarab1959]

0:42 - As part of Define category 1:12 - Scenario based Example 4:23 - What we actually did 5:46 - Use of Bulk collect Instead of For Loop 8:28 - To see the Performance difference 11:34 - Performance Iterations

[@kumarsuraj2238]

Wow... Amazing work. One of the best guiding videos. Crystal clear!

[@SivaAcademy]

Thank you

[@mukeshchitte3870]

Hello Siva, Eagerly waiting ur videos especially on performance tuning, thanks a lot.

[@SivaAcademy]

Thank you so much 🙂, will upload soon, please stay tuned.

[@vishalsaxena5081]

@@SivaAcademy BULK COLLECT PROGRAM CAN SUPPORT IN FORMS AND REPORT???

[@odiboufuoma3659]

wow. awesome practical explanation. you explain every details at ease thanks man. keep up👊👍

[@angeltamizhini3048]

Clear explanation kindly upload SQL joins and subquery SQL loader video series

[@SivaAcademy]

Thank you, please stay tuned

[@bhushanpalse516]

Excellent sir as always

[@SivaAcademy]

Thank you bro

[@anil5335]

Hi sir, how can we pass the collection to another procedure as a parameter.

[@swarajbande1506]

Hello sir, in one of the nested table video you said we cannot use function extend in nested table , I am bit confuse here we used extend in type table

[@MrSunnychadha]

why to use fetch (cursor) while bulk collect . because bulk collect works without cursor too right. whats the major difference in using fetch with bulk collect

[@vimalkrishna4730]

Why are we stroring at the last location?

[@joseronald111]

Thank you Sir, as always very good explanation and nice video👍

[@SivaAcademy]

Always welcome :-)

[@naveentaneja7089]

Wow whats a channel. Superb

[@SivaAcademy]

Thanks and welcome

[@ajinkyagaikwad2387]

Could you please share the video link for bulk exception , Thanks in advance

[@sandip1969]

Bulk collect limit clause is not there but video is good

[@saiswaroop3570]

Sir, Can we declare nested table of record type, and retrieve them ??

[@DeepthiSuggula]

Excellent !!!!!!!!

[@SivaAcademy]

Thank you

[@SriLife2]

Can u make video on pipeline functiion and constructors in plsql

[@SivaAcademy]

sure, please stay tuned, will add in upcoming videos

[@shubhendrasingh8486]

very nice explanation sir. sir please make more videos on performance tuning and also sir please make videos on cast and multiset functions please

[@SivaAcademy]

Sure please stay tuned for more videos

[@rohanyadav1839]

Thanks sir.... Can you make video on PLSQL XML functions and Bulk exception function.

[@SivaAcademy]

Sure, please stay tuned, will cover in upcoming video series.

[@pradeepverma8277]

Nice topic siva,

[@SivaAcademy]

Thank you 🙂

[@anishashaji4133]

hi Siva, could you do a series on ETL concepts

[@SivaAcademy]

Sure, please stay tuned

[@chandrababubollu4508]

Nice explanation Sir 👌

[@SivaAcademy]

Thanks and welcome

[@kumaranpppn6223]

Great

[@SivaAcademy]

Thank you

[@dalvisidd]

Hello siva sir, can u please post videos on in- bind and out-bind operations similar to bulk collect video which u have already shared.

[@SivaAcademy]

Yeah Siddhesh, sure, please stay tuned

[@govindugovindu617]

How do we raise the exception in bulk collect clause and how write exception in ur explained programs

[@SivaAcademy]

Sure, will explain in upcoming video series, please stay tuned.

[@Pokuri85]

Hello Sir. Can you explain what are the challenges you face while using the collection

[@patinoricardo]

por favor, podrian poner subtitulos a todos tus videos? son todos muy interesantes y quiesiera sacarle provecho. muchas gracias.

[@SivaAcademy]

Sure I will try to put subtitles from next video onwards, Please stay tuned

[@patinoricardo]

@@SivaAcademy Thank you

[@minicat1983]

Please upload next session.

[@SivaAcademy]

Yeah , next week, please stay tuned

[@abbeydudeuk]

there are 2 duplicate part 3 videos. looks like instead of uploading returning into clause video for bulk collect u uploaded the same video twice.

[@SivaAcademy]

Ohh, let me check, thanks for letting me know

[@nk2506]

@@SivaAcademy Thank you Siva you are an amazing teacher.. Yes out of 6 videos 2 are same related to define category.. please can you check and reupload the missing returning into clause video

[@LIKHITH_MS]

Sir please make video on trigger mutation error

[@SivaAcademy]

Hi Likhith, I have already posted, please look into video no 52,53 and 54. Link for video no 52 is given here kzbin.info/www/bejne/fGaQlJeCr6yartE