Lesson 1
Using Oracle parameters
You have already seen some examples of parameters in previous modules in this course.
This module examines PL/SQL Stored Object parameters in detail.
Module objectives
By the end of this module, you will be able to:
- Describe the uses of parameters in SQL*Plus and PL/SQL
- Use parameters when starting a SQL*Plus script
- Describe the ways in which parameters are used in PL/SQL
- Place a parameter in a procedure
- Use parameters and the RETURN command appropriately
- Identify correct syntax for using parameters with cursors