Program Units
The PL/SQL programming language allows you to create a variety of named program units (containers for code). They include:
- Procedure
Program that executes one or more statements.
- Function
Program that executes one or more statements and that directly returns a value.
- Package
Container for procedures, functions, and data structures.
- Triggers
Program that executes in response to database changes.
- Object type
Oracle’s version of a class in an object-oriented language; object types can contain member procedures and functions. An object type can contain PL/SQL code in its methods.
Get Oracle in a Nutshell now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.