PL/SQL tutorial 44 : Introduction to PL/SQL Packages in Oracle Database By Manish Sharma

[@nk2506]

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 !!

[@ravirajkadam9323]

Thanks Manish. You have explained very well package and package body in simple language.

[@vinod901]

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 :)

[@darkshadow6962]

What a energy 🫡🫡🫡

[@Rebellionrider]

Thanks! I put a lot of passion into my work. Which SQL topic are you most excited to learn more about?

[@darkshadow6962]

@@Rebellionrider I think you created all topic 😀😀😀

[@Rebellionrider]

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/

[@baby_videos9746]

Amazing bro.. ur vedios are very helpful..

[@SivaKumar-rv1nn]

Thankyou sir

[@vikasjha6541]

Awesome Explanation but Where is the link of ur blog Manish?

[@Rebellionrider]

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

[@vanashriswami893]

Only therotical....not practical examples explained

[@vishalsaxena5081]

why we use package pls explain

[@loveyourself....4200]

🙌🏻🙌🏻🙌🏻🙌🏻

[@Rebellionrider]

🎉🎉🎉 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! 🌟🚀

[@bilalasif7519]

how we can install missing packages of oracle 11g in solaris 10 ??? help me

[@navingopaul5855]

*replace, not repalce

[@VishalGupta-oh7mb]

can we include trigger in the pakage .....anyone here?

[@Rebellionrider]

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

[@michaeltsao8580]

Typo: "REPLACE" at 3:20. Nice video though.

[@dishindayani25]

Hindi me bol ...