Modularity allows you to break your code into manageable, well-defined logical units. Each of these units in PL/SQL is called a program unit, or a subprogram. PL/SQL has two types of subprograms called procedures and functions. This lesson covers the structure of subprograms and how to invoke them. At the end of this lesson, you should be able to Determine the types of program units and where to use them. Explain the differences between and benefits of procedures and functions. Develop subprograms. Invoke subprograms from Procedure Builder | 20 Modularizing Programming with Subprograms ORACLG Objectives Determine the types of program units and where to use them. Explain the differences between and benefits of procedures and functions. Develop subprograms. Invoke subprograms from Procedure Builder. Schedule Timing 60 minutes 20 minutes 80 minutes Topic Lecture Practice Total Class Management Note Files required for lesson are DEMO PRACTICE 20-2 Introduction to Oracle SQL and PL SQL Using Procedure Builder Objectives Modularity allows you to break your code into manageable well-defined logical units. Each of these units in PL SQL is called a program unit or a subprogram. PL SQL has two types of subprograms called procedures and functions. This lesson covers the structure of subprograms and how to invoke them. At the end of this lesson you should be able to Determine the types of program units and where to use them. Explain the differences between and benefits of procedures and functions. Develop subprograms. Invoke subprograms from Procedure Builder. Class Management Note This lesson is designed to give students an overview of a subprogram because Procedure Builder can only store subprograms not anonymous blocks. Therefore use this lesson as a high level overview with the details to follow in the next lessons. Modularizing Programming with Subprograms .
