PL/SQL tutorial 86: Multiple Bind Variable with Execute Immediate of Dynamic SQL By Manish Sharma

Manish Sharma from RebellionRider.com presents how to use multiple bind variables by applying using clause of execute immediate statement in native dynamic SQL.
------------------------------------------------------------------------
►►►LINKS◄◄◄
Blog: www.rebellionr...
Previous Tutorial
► PL/SQL tutorial 45 • PL/SQL tutorial 85: Ex...
-------------------------------------------------------------------------
►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
/ rebellionrider
/ rebellionrider
plus.google.co...
/ mannbhardwaj
__Facebook Official Page of Manish Sharma__
/ therebellionrider
__Facebook Official Page of RebellionRider.com__
/ rebellionrider.official
You can also Email me at
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

[@Jitenderkhokhar]

Great overall content and great playlist, it's detailed to the point it should be and a must watch for the beginners.
Could you please add a playlist for optimization techniques and a specific one for AWR reports if you can, it will be really great !

[@nagarajkrishnan2543]

It will b very useful

[@stevenmacdonald1968]

Thank you manish. great videos.

[@Rebellionrider]

You are most welcome ☺️👍

[@aniketjagdale7765]

Please make detailed videos on table partitioning, dbms_debug, query optimization, dbms_stats, awr report and dbms_scheduler.

[@reeshmashama]

incredible explanation

[@Rebellionrider]

I'm delighted to hear that you found the explanation incredible! 🌟 Thank you for your kind words! 👍

[@kalyanc4829]

How does it become dynamics sql as we are hard coding here with "using"? Please explain?

[@kumarsushantmhaske4330]

Dear sir plz make a vedio on debugging a plsql procedure.

[@lovelyanil9776]

Nice vedio .better to exapalin with defenations for concepts it will help us

[@kshanmugasundaram5884]

Hi manish i need your help what the purpose of using this procedure==> (exec dbms_workload_repository.create_snapshot();)

[@ranipandian2945]

This is used to create a snapshot using AWR for finding out the history of Activities in Database level . This is used during Tuning the DB

[@sibeshghosh2004]

Dear Sir, Thank you for this video series it almost covered every topic of Plsql, but I think plsql object type is yet to cover here,so do you have any plan to make video on that?

[@Rebellionrider]

Thank you for reminding me. I’ll cover those in upcoming videos. By the way If you could quickly master any advanced SQL skill, what would it be and why? 😊🌟

[@sibeshghosh2004]

@@Rebellionrider Hello Sir, previously I was a .net resource so I have worked in plenty project in different framework of .net and along with that SQL server as backend,
But recently moved into Oracle Plsql so you can say currently I am in learning phase of this technology and got immense help from your tutorial series and after going through of all tutorial here I think you are only need to cover Plsql object type and compound trigger.
So if you please upload tutorial on these topics will be definitely very helpful.

[@Rebellionrider]

It's great to hear you've found the tutorials helpful! I'll definitely consider covering PL/SQL object types and compound triggers in upcoming videos. Stay tuned for more content! If you have any more topics you'd like me to delve into, feel free to let me know. Where do you currently stand in your SQL proficiency: beginner, intermediate, or advanced? Your perspective is valuable! 😊🌟

[@sibeshghosh2004]

​​@@RebellionriderHello Sir, Thank you very much for giving me chance to remind you for pending topics,till now I think you are yet to discuss object type in Plsql and compound trigger, going forward if I find any other topic which are pending I will definitely remind you 😊
And could you please upload tutorial on 'object type' sooner as it is emergency for me to know the concept.
And Sir I can consider myself somewhere between beginner and intermediate as I have switched my technology recently but as I have mentioned earlier your tutorial series is helping me to learn this topic quickly and efficiently 🎉

[@lakshayvinayak440]

Sir pls upload videos on case statement

[@mmohan692]

Good 👍

[@muralimohan139]

i am not able to update number datatype

[@pritamkumohanty85]

Update table
Set column name='value'
From table
where column='valu'
try it