3 PLSQL Performance Tuning | Bulk Collect Part 2 | Types of Bulk Binding

3 PLSQL Performance Tuning | Bulk Collect Part 2 | Types of Bulk Binding
Oracle Collection play list
• 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...

[@sahendramansingh7896]

I have been working on plsql for about 14 years and I can't explain/teach the way you do :) Commendable work I must say. Keep up the good work. 👌👌

[@SivaAcademy]

My pleasure bro, thank you for your comments 💐🙏

[@poojasubramani2301]

Thank you very much this channel is one stop solution for PLSQL and SQL related aspects, your dedication towards work is really inspiring Keep doing this. Thanks a ton!

[@SivaAcademy]

My pleasure, welcome 💐💐🙏

[@karnarajmahajan8861]

Thanks sir for your valuable contain on this qauratine time. By referring your videos I'm enhanced my technical skills.

[@SivaAcademy]

Welcome bro, got some more time due to qauratine , so thought of using it for everyone

[@vivektarab1959]

0:41 - Types of Binding 1:04 - So here is a Block Structure 1:21 - Suppose if you have a collection 1:48 - So here is a simple program 2:11 - Out Bind 4:03 - Details me Keywords

[@jrdesaria]

Wonderful explanation

[@devanaidu9406]

Hi Sir, thank you for sharing valueble information and please make performance tuning concepts step by step ike 1)what is optimization,2).what is explain plan,3)what is tk proof 4)what is gather stats,5)what are parallel hints ,please explain them step by step asap

[@SivaAcademy]

Sure bro, i will add all these to upcoming videos, please stay tuned

[@devanaidu9406]

@@SivaAcademy Thank you sir, we are waiting every day for your upcoming videos, we should be thankful for sharing your knowledge to us...you have great talent sir, your all videos extremely helpful us..keep sharing sir and God bless you..

[@SivaAcademy]

Thank you 🙏🙏🙏🙏🙏

[@devanaidu9406]

@@SivaAcademy Its my pleasure sir, please make tuning videos asap..how to resolve.. performance issues step by stepand how do use hints.. when do we use specific hint like that..thank you sir

[@SivaAcademy]

Sure Deva, will add soon, please stay tuned

[@karthiram8393]

Sir ur explanation is so good and easy to understand ...it helps to improve our knowledge...keep posting....I am having query... could please explain about parrallel table function

[@SivaAcademy]

sure, will cover the table function in upcoming video, please stay tuned.

[@nimmylizthomas]

Good work. Concepts made simple!

[@SivaAcademy]

Thank you

[@sagarrahate5140]

Thank you so much Sir. Very well explained...

[@SivaAcademy]

Welcome bro

[@renevillalta27]

Thanks for all the videos. Waiting for the next videos of this serie

[@SivaAcademy]

My pleasure 🙏 thank you, sure please stay tuned for more videos

[@sujaa1000]

Thanks Siva, very helpful, waiting for subsequent videos. Regards, Sujaa

[@SivaAcademy]

Welcome, added few more videos in the same series

[@ankitasongire2781]

Hello sir , In performance tunning playlist there is no seperate video explaination for out bind type , could you please explain it sir. Thank you.

[@JhonJhon-qw1kc]

@1:12 i think u misspell here , it should be “how bulk binding INCREASES the performance “

[@QhairunnisaSyed]

Hi Sir, Thankyou so much for your videos. I also wanted to learn python do you make videos on python too? Because you explain it very clearly and so I wanted same kind of explanation for python too

[@arunrocketz]

Thank you sir for this video.. Preparing for interview .Telephonic interview for tcs scheduled on friday for me for plsql developer position.Iam going thru all of ur videos which gives me confident that i ll get placed. One request sir can u make videos on job scheduling,hints and explain plan..

[@SivaAcademy]

Sure, All the best arun. Please stay tuned, i will add on upcoming videos.

[@arunrocketz]

@@SivaAcademy Tysm sir..😊

[@vsr1727]

Thank you Siva for the sharing

[@SivaAcademy]

My pleasure 😊

[@deepakjagdale6215]

Thank you Siva sir

[@SivaAcademy]

Welcome

[@shahanakhan8299]

Thanks for these videos, are the next videos in the series uploaded? I am not able to find those.

[@SivaAcademy]

Please stay tuned, will try to post soon

[@sujaa1000]

Hi Siva, The 3 videos on Bulk Binding was very helpful, you have mentioned there will be subsequent videos, will you be uploading any? if so it would be very helpful. Thanks a lot, Regards, Sujaa

[@SivaAcademy]

yeah, i am preparing for next video, will try to post soon, please stay tuned.

[@shashank2004]

Awsome video bro

[@SivaAcademy]

Thanks bro

[@r.r.r2367]

Bulk Collect is only better than the "FOR" loops.

[@nikitakharade1386]

Hello Sir,have you made any video on Forall clause?

[@SivaAcademy]

Not yet!, next video in this series will be forall, please stay tuned

[@ananthraj5454]

Nice

[@SivaAcademy]

Thanks

[@dineshkumar-vp9dm]

For clause and forall clause different between plsql

[@SivaAcademy]

Please stay tuned, next video in the same series will be forall and for only.

[@shaikrasheed2861]

Sir,What is flag in plsql?

[@SivaAcademy]

Nothing like a flag, sometime a variable of varchar2(1) datatype is to store indicator values like Y or N to denote YES or NO, referred as flag......Please let me know if you are looking for any specific info

[@rjraob]

🤝

[@SivaAcademy]

thank you

[@dineshkumar-vp9dm]

Performances turning one by one steps plsql pls send the video

[@SivaAcademy]

sure, please stay tuned, will be posting soon.