Blocks, Functions, and Procedures

  • Donald J. Bales


In this chapter, as the title suggests, you’ll learn about the foundational structures of PL/SQL: blocks, functions, and procedures. Blocks define the structures upon which functions and procedures are built. Functions and procedures are very similar, but distinct, in that a function returns a value to a calling function or procedure, while a procedure does not. So let’s begin our discussion of PL/SQL by starting with its foundation: the block.


Block Structure Package Spec Test Unit Select Statement Exception Handler 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.

Copyright information

© Donald J. Bales 2015

Authors and Affiliations

  • Donald J. Bales
    • 1
  1. 1.ILUnited States

Personalised recommendations