Hey Manish, You are doing a great job by explaining pl/sql code basics. I request you to continue uploading other concepts soon. I know in order to gain knowledge better we need to practice them. Can you please also provide some exercises on these topics or a link where we can refer them. Also please share more practical scenarios and advance concepts. Thanks a lot !!
Hi Manish, First of all thanks a lot for your tutorials, can we expect IN and OUT parameter concepts used in procedures in your tutorials. thanks in advance :)
Haha, I've tried to cover all the PL/SQL topics! 😊 If you're looking to dive even deeper, check out my book "Mastering SQL Windows Function." It's on discount for the next 2 hours only. Don't miss out! 📚✨ dataprofy.com/product/mastering-sql-windows-functions/
🎉🎉🎉 Thank you! 🙌 If you have any questions or suggestions for future content, feel free to share! By the way, if you could quickly master any advanced SQL skill, what would it be and why? Let's keep the SQL excitement going! 🌟🚀
Yes Off course you can In fact, using packages to group database objects such as triggers, functions, and procedures is a best practice in Oracle development. By encapsulating triggers within a package, you can improve code modularity, reduce naming conflicts, and improve performance by avoiding unnecessary parsing of code. Here is an example CREATE OR REPLACE PACKAGE my_package AS PROCEDURE my_procedure; -- Define trigger within the package body CREATE OR REPLACE TRIGGER my_trigger AFTER INSERT ON my_table FOR EACH ROW BEGIN -- write your Trigger logic here END; END my_package; /
Hey Manish,
You are doing a great job by explaining pl/sql code basics. I request you to continue uploading other concepts soon. I know in order to gain knowledge better we need to practice them. Can you please also provide some exercises on these topics or a link where we can refer them. Also please share more practical scenarios and advance concepts. Thanks a lot !!
Thanks Manish. You have explained very well package and package body in simple language.
Hi Manish,
First of all thanks a lot for your tutorials, can we expect IN and OUT parameter concepts used in procedures in your tutorials.
thanks in advance :)
Amazing bro.. ur vedios are very helpful..
how we can install missing packages of oracle 11g in solaris 10 ??? help me
Awesome Explanation but Where is the link of ur blog Manish?
I am so sorry I completely forgot to put the link in the description. Thanks for reminding me.
And here is the link to the blog bit.ly/packages-intro
Only therotical....not practical examples explained
What a energy 🫡🫡🫡
Thanks! I put a lot of passion into my work. Which SQL topic are you most excited to learn more about?
@@Rebellionrider I think you created all topic 😀😀😀
Haha, I've tried to cover all the PL/SQL topics! 😊 If you're looking to dive even deeper, check out my book "Mastering SQL Windows Function." It's on discount for the next 2 hours only. Don't miss out! 📚✨ dataprofy.com/product/mastering-sql-windows-functions/
Thankyou sir
why we use package pls explain
🙌🏻🙌🏻🙌🏻🙌🏻
🎉🎉🎉 Thank you! 🙌 If you have any questions or suggestions for future content, feel free to share! By the way, if you could quickly master any advanced SQL skill, what would it be and why? Let's keep the SQL excitement going! 🌟🚀
can we include trigger in the pakage .....anyone here?
Yes Off course you can In fact, using packages to group database objects such as triggers, functions, and procedures is a best practice in Oracle development. By encapsulating triggers within a package, you can improve code modularity, reduce naming conflicts, and improve performance by avoiding unnecessary parsing of code.
Here is an example
CREATE OR REPLACE PACKAGE my_package AS
PROCEDURE my_procedure;
-- Define trigger within the package body
CREATE OR REPLACE TRIGGER my_trigger
AFTER INSERT ON my_table
FOR EACH ROW
BEGIN
-- write your Trigger logic here
END;
END my_package;
/
*replace, not repalce
Typo: "REPLACE" at 3:20. Nice video though.
Hindi me bol ...