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 - Oracle Database Tutorial
From the course: Oracle Database 12c: Advanced SQL
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…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
-
-
-
-
(Locked)
Introduction to sequences2m 8s
-
(Locked)
Creating sequences7m 6s
-
(Locked)
Using identity columns7m 23s
-
(Locked)
Introduction to table triggers3m 1s
-
(Locked)
Creating triggers5m 24s
-
(Locked)
Introduction to PL/SQL procedures3m 55s
-
(Locked)
Introduction to PL/SQL functions1m 21s
-
(Locked)
Introduction to PL/SQL packages2m 21s
-
(Locked)
Creating PL/SQL procedures and functions7m 40s
-
(Locked)
Creating synonyms4m 24s
-
(Locked)
Creating simple views2m 24s
-
(Locked)
Creating complex views5m 13s
-
(Locked)
-
-