@@SivaAcademy i have watched all your videos and started my job search in December for plsql and SQL developer positions.. I have attended more than 10 interviews , and you should me believe me I have selected in every interview I attended...
Great Siva Sir.... Wish you Happy New🎉🎊May this year filled with lots of joy and happiness....and Thank you so much for making such an amazing videos which really helped me alot...Thank you once again. :)
Nice video but if we want to insert huge amount of data like more than 5K then it will insert in a faster way or wether normal insert method will be faster?
@@SivaAcademy Yes, basically this method is helpful when we have to insert less amount of data in multiple tables. Thanks a lot for the video. I have a question regarding another topic which is selection of records from the inner query. We can compare multiple columns between outer and inner query at the same time by this method:- SELECT * FROM TAB1 WHERE (COL1, COL2, COL3) IN (SELECT COL1, COL2, COL3 FROM TAB2). I have 2 table of 50 columns so just wanted to know that is there any way that we can compare all columns of both the tables with the above method but without writing all the columns?
I am not very sure, however this is very interesting question, let me try to find if any alternative available without mentioning all the columns, if I find any best method, I will post back here... Also if you find any best solution also, please post your comments here, will be helpful for lot of people
Such a thoughtful idea of releasing the knowledge video on New year🥳
Happy New year 💐🎉
Happy New year Sir, one of the best plsql learning source I have ever come across... Great work Sir. Words aren't enough to thank you.. 🙏
Thanks a lot 🙏, wishing you and your family a very happy new year 🎉🎉🎉🌟🌟🌟
Thank you so much sir for this video :), very well explained! managed to clear these concepts with such ease! 👌😊
Glad to hear that
Happy New Year .. Hats off to your way of explaining
Wishing you and your family a very happy new year 💐🎉🥳
Started my new year with your super knowledge video.
Thank you very much for ur time for teaching us.
Wish you a very happy new year Brother!!
Thank you bro, wishing you and your family a very happy new year 🎉🌟🌟🎉
@@SivaAcademy i have watched all your videos and started my job search in December for plsql and SQL developer positions..
I have attended more than 10 interviews , and you should me believe me I have selected in every interview I attended...
Thats great, wishing you all the best 👏👍👍💐💐
Happy New year Siva.. Started new year with your videos🙂🙂🙂🙂
Welcome, wishing you and your family a very happy new year 🎉🌟🎉🎉🎉🌟
Thank u sir for sharing this video..it's really useful
Welcome 👍
Great Siva Sir.... Wish you Happy New🎉🎊May this year filled with lots of joy and happiness....and Thank you so much for making such an amazing videos which really helped me alot...Thank you once again. :)
Welcome Rajiv, wishing you and your family a very happy new year 💐🎉🌟🎉🌟
Happy New Year Sir,
Learned a lot from you, Thanks.
Wishing you and your family a very happy new year 💐🥳🌟🎉
Great Video! NO COVID.. Happy New Year sir!!
Wishing you and your family a very happy new year 💐🌟🎉🎉, lets us hope for healthy and covid free year 2021🙂
very nice and simple explanation.
Thank you
Thank you and wish you happy new year
Wishing you and your family a very happy new year 💐🎉🎉🌟
Thanks bro, Learned a lot from your videos. Happy new Year..
Welcome bro, wishing you and your family a very happy new year 🎉🌟🎉🎉🎉🌟
@@SivaAcademy I hope You will share performance tuning tips as well.
Yeah Aravind, please stay tuned
Nicely explained
Happy new year sir.
happy New year Govind 💐🌟🎉
Hi Sir..thank you for released new video in new year 😉..nice explanation Sir.
Thank you Deva, wishing you and your family a very happy new year 🎉🌟🌟🎉
@@SivaAcademy thank you Sir.
what are some use case applications where i would need a query like this
Thanks bro. Wish you happy new year
Welcome bro, wishing you and your family a very happy new year 💐🌟🎉🎉🎉🌟🎉🎉
Hi Sir.... Happy New Year🎇🎉🎊🎇🎇
Thanks Jagadeesh, wishing you and your family a very happy new year 🎉🌟🎉🌟🎉🌟
Happy new year sir♥️
Great work
Wishing you and your family a very happy new year 🎉🎉🌟🌟🎉🎉🌟🌟
Nice video... Can you please make a video on "Deterministic" and "RESULT_CACHE". and what is difference between these function.
Sure, please stay tuned
Thanks again Siva!
Always welcome
Wish you happy new year sir
Wishing you and your family a very happy new year 🎉🎉
Nice video but if we want to insert huge amount of data like more than 5K then it will insert in a faster way or wether normal insert method will be faster?
I don't see any difference in performance, however this method is specifically for multi table insert
@@SivaAcademy ok, I asked because inserting 5k records in all the tables should take time, if it is not then this method will be very helpful.
Yes, you are right, this method is helpful if planning to insert conditionally into multiple tables
@@SivaAcademy Yes, basically this method is helpful when we have to insert less amount of data in multiple tables. Thanks a lot for the video.
I have a question regarding another topic which is selection of records from the inner query.
We can compare multiple columns between outer and inner query at the same time by this method:-
SELECT * FROM TAB1 WHERE (COL1, COL2, COL3) IN (SELECT COL1, COL2, COL3 FROM TAB2).
I have 2 table of 50 columns so just wanted to know that is there any way that we can compare all columns of both the tables with the above method but without writing all the columns?
I am not very sure, however this is very interesting question, let me try to find if any alternative available without mentioning all the columns, if I find any best method, I will post back here... Also if you find any best solution also, please post your comments here, will be helpful for lot of people
Wishing you happy new year with lot's of love and happiness!!
Thank you, wishing you and your family a very happy new year 💐🎉🎉🌟
Well explained 👍
Welcome
Happy new year🎉🎉 sir
Wishing you and your family a very happy new year 🥳🥳
Happieee New year Sir..
Wishing you a very happy new year 🎉🌟🎉🎉🌟
Happy New Year Sir 🎉🎉🎉
Wishing you and your family a very happy new year 💐🌟🎉
Really useful
Glad to hear that
Great content
Thank you
Hi sir
Happy New Year.. could you please tell me
How I can delete row from parent table without deleting from child table??
Happy New sir🙏❤️👍
Happy new year sir🙏👍
Happy New year 💐🎊🎊
How to insert multiple tables with different data in multiple tables at once..can you pls explain
In a similar manner. Is there anything so that i can UPDATE multiple table?
I don't think so , updating multiple table in single query is not possible, however I will check if any other option available
@@SivaAcademy Thanks for your response
Can u pls put video for SQL BACKTRACE
Sure please stay tuned