PL/SQL - What is Package || Pl/SQL - Reasons to use package || Pl/SQL - Syntax of Package
►►► Title: PL/SQL - What is Package || Pl/SQL - Reasons to use package || Pl/SQL - Syntax of Package
►►► Contents:
PL/SQL - What is Package || Pl/SQL - Reasons to use package || Pl/SQL - Syntax of Package,
What is package?
------------------------
A package is a schema object that groups logically related PL/SQL types, variables, constants, subprograms, cursors, and exceptions.
A package is compiled and stored in the database, where many applications can share its contents.
When you call a package, it is loaded in PGA(program/private global area) and then execute its logics
Reasons to Use Packages
-----------------------
Packages support the development and maintenance of reliable, reusable code with the following features:
Modularity
Packages let you encapsulate logically related types, variables, constants, subprograms, cursors, and exceptions in named PL/SQL modules. You can make each package easy to understand, and make the interfaces between packages simple, clear, and well defined. This practice aids application development.
Easier Application Design
When designing an application, all you need initially is the interface information in the package specifications. You can code and compile specifications without their bodies. Next, you can compile standalone subprograms that reference the packages. You need not fully define the package bodies until you are ready to complete the application.
Hidden Implementation Details
Packages let you share your interface information in the package specification, and hide the implementation details in the package body. Hiding the implementation details in the body has these advantages:
You can change the implementation details without affecting the application interface.
Application users cannot develop code that depends on implementation details that you might want to change.
Added Functionality
Package public variables and cursors can persist for the life of a session. They can be shared by all subprograms that run in the environment. They let you maintain data across transactions without storing it in the database. (For the situations in which package public variables and cursors do not persist for the life of a session, see "Package State".)
Better Performance
The first time you invoke a package subprogram, Oracle Database loads the whole package into memory. Subsequent invocations of other subprograms in same the package require no disk I/O.
Packages prevent cascading dependencies and unnecessary recompiling. For example, if you change the body of a package function, Oracle Database does not recompile other subprograms that invoke the function, because these subprograms depend only on the parameters and return value that are declared in the specification.
Easier to Grant Roles
You can grant roles on the package, instead of granting roles on each object in the package.
►►► Topics
What is a package in PL SQL?,
What are types of packages in PL SQL?,
What is package in PL SQL interview questions?,
How to call a package in PL SQL?,
pl sql what is package?,
PL/SQL - What is Package?,
Pl/SQL - Reasons to use package,
Pl/SQL - Syntax of Package,
ما هي الحزمة في PL SQL Mcq ؟،
ما هي أنواع الحزم في PL SQL ؟،
ما هي الحزمة في أسئلة المقابلة PL SQL ؟،
كيفية استدعاء حزمة في PL SQL ؟،
رر SQL ما هي الحزمة ؟،
PL / SQL - ما هي الحزمة ؟،
Pl / SQL - أسباب استخدام الحزمة ،
Pl / SQL - بناء جملة الحزمة ،
PL SQL Mcq में पैकेज क्या है?,
पीएल एसक्यूएल में पैकेज किस प्रकार के होते हैं?,
पीएल एसक्यूएल साक्षात्कार प्रश्नों में पैकेज क्या है ?,
पीएल एसक्यूएल में पैकेज कैसे कॉल करें ?,
pl sql पैकेज क्या है ?,
PL/SQL - पैकेज क्या है?,
Pl/SQL - पैकेज का उपयोग करने के कारण,
Pl/SQL - पैकेज का सिंटैक्स,
PL SQL Mcq এ একটি প্যাকেজ কি?,
পিএল এসকিউএল-এ কী ধরনের প্যাকেজ আছে?,
পিএল এসকিউএল ইন্টারভিউ প্রশ্নে প্যাকেজ কি?,
কিভাবে PL SQL এ একটি প্যাকেজ কল করবেন?,
pl sql প্যাকেজ কি?,
PL/SQL - প্যাকেজ কি?,
Pl/SQL - প্যাকেজ ব্যবহার করার কারণ,
Pl/SQL - প্যাকেজের সিনট্যাক্স,
¿Qué es un paquete en PL SQL Mcq?,
¿Cuáles son los tipos de paquetes en PL SQL?,
¿Qué es el paquete en las preguntas de la entrevista PL SQL?,
¿Cómo llamar a un paquete en PL SQL?,
pl sql ¿qué es el paquete?,
PL/SQL - ¿Qué es el paquete?,
Pl/SQL - Razones para usar el paquete,
Pl/SQL - Sintaxis del paquete,
🔗Content🔗: https://github.com/rezaice07/youtube-...
🔗LINKS🔗
Website: http://rejawebs.com/#/
LinkedIn: / md-rezoyanul-islam-096a3775
►►► Find me on Social Media◄◄◄
Facebook: / rezoyanul.reza
✉ Contact with me
Email: [email protected]
❤ Make sure you SUBSCRIBE and be the 1st one to view newly created videos!
Hope you guys enjoy this tutorial..
Don't forget to subscribe my channel.
Keep watching the next tutorial.
Thanks
Watch video PL/SQL - What is Package || Pl/SQL - Reasons to use package || Pl/SQL - Syntax of Package online without registration, duration hours minute second in high quality. This video was added by user rejawebs 01 March 2023, don't forget to share it with your friends and acquaintances, it has been viewed on our site 37 once and liked it 0 people.