Chapter Ten. PL/SQL Program Units

10.1 PROCEDURES

10.2 FUNCTIONS

10.3 SUBPROGRAM ENCAPSULATION: INTRODUCTION TO PACKAGES

10.4 PACKAGE SPECIFICATION

10.4.1 Syntax and Style

10.4.2 Developing a Specification

10.5 PACKAGE BODY

10.6 APPLICATION PARTITIONING

10.7 DATA ABSTRACTION

10.8 PARAMETERS AND MODES

10.8.1 IN Mode (Default) Is a Constant

10.8.2 IN OUT Mode

10.8.3 OUT Mode

10.8.4 Functions and Modes

10.8.5 Named versus Positional Notation

10.8.6 Default Parameters

10.8.7 Scaling Code with Defaults

10.8.8 %TYPE

10.9 OVERLOADING

This chapter presents PL/SQL from a software engineering perspective. PL/SQL has the following program units:

  • Procedure

  • Function

  • Package specification

  • Package body

Stored procedures are PL/SQL program units that exist as objects in the Oracle ...

Get Programming Oracle® Triggers and Stored Procedures, Third Edition 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.

Start your free trial