Creating Stored Procedures and Functions


Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number



Overview/Description
To create and execute a stored function and call, and remove and view stored functions in PL/SQL

Target Audience
Database administrators, application developers, and database operators

Prerequisites
Familiarity with Oracle Database 10g database technology; an understanding of the basic concepts of relational databases and the SQL programming language; ability to write queries against single and multiple tables, manipulate data in tables, create database objects, and query metadata

Expected Duration (hours)
2.8

Lesson Objectives

Creating Stored Procedures and Functions

  • create, remove, and view PL/SQL stored procedures.
  • use IN, OUT, and IN OUT parameter modes to pass values to and from stored procedures and programs.
  • outline how to view values returned by OUT parameters.
  • create stored procedures with suitable parameters.
  • assign values to multiple parameters in a stored procedure and invoke that procedure.
  • handle exceptions in stored procedures.
  • execute a stored procedure in which you have assigned parameter values and handled exceptions.
  • create and execute a stored function.
  • call, remove, and view stored functions in PL/SQL.
  • create, call, and remove stored functions in PL/SQL.
  • Course Number:
    216563_eng