From the course: Oracle Database 12c: Advanced SQL

Unlock the full course today

Join today to access over 24,700 courses taught by industry experts.

Introduction to PL/SQL packages

Introduction to PL/SQL packages

- [Narrator] The Oracle PS/SQL language enables you to place multiple subprograms, such as procedures, and group them together inside a single PL/SQL package. A PL/SQL package is a database schema object similar to PL/SQL functions and procedures but one which groups related elements, such as PL/SQL types, variable, functions and procedures together. A PL/SQL package can contain multiple procedures or functions or types and so on inside it. Encapsulating or grouping different elements that are part of the same business logic group inside a single PS/SQL package is considered a good programing best practice for the Oracle Database. Procedures or functions which are defined within a PS/SQL package are sometimes also known as packaged subprograms. A PS/SQL package will have two mandatory parts. A package specification, which is declared as the interface to the package, it essentially declares the types, variables…

Contents