Part IV: Modular Code

Part IV of this tutorial goes beyond the individual components of the PL/SQL language and explains how to build complete PL/SQL applications using program modules.

• Procedures and Functions, presents the basics of modular developing in PL/SQL using blocks, procedures, functions, and parameters.
• Packages, describes how to build packages, one of the least understood and least utilized features of PL/SQL.
• Calling PL/SQL Functions in SQL, describes how you can construct PL/SQL functions and call them from SQL.