RelationalDBDesign
RedhatLinuxSys Seomining
prev next prev next
Course navigation
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:
  1. Describe the uses of parameters in SQL*Plus and PL/SQL
  2. Use parameters when starting a SQL*Plus script
  3. Describe the ways in which parameters are used in PL/SQL
  4. Place a parameter in a procedure
  5. Use parameters and the RETURN command appropriately
  6. Identify correct syntax for using parameters with cursors
The next lesson shows how to place a parameter in a procedure.
Course navigation