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; /