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 O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.