Title: Learning Objectives
Course: Introduction to Oracle SQL and PL/SQL (10610) > Section: Competency Modules

After completing this chapter, you should be able to:

- Create a stored function
- Use OUT parameters in functions
- Include multiple RETURN statements in a function
- Use a RETURN statement in a procedure
- Use constraints of actual and formal parameters
- Control the passing of parameter values
- Work with function purity levels
- Reference the data dictionary for program units
- Delete program units