Oracle9i PL/SQL Procedures, Functions, & Packages


Overview/Description
Target Audience
Expected Duration
Lesson Objectives
Course Number

Overview/Description
This course introduces users to the basics of PL/SQL subprograms. Users will learn how to build and invoke procedures and functions. This course also covers debugging PL/SQL subprograms using Procedure Builder. Additionally, users will learn how to trap and handle errors in a PL/SQL block. This course also covers the basics of packages and how to create and use them.

Target Audience
The intended audience for this course is, Application Developers, Database Administrators and Tech Support Professionals.

Expected Duration (hours)
8.0

Lesson Objectives

Oracle9i PL/SQL Procedures, Functions, & Packages

  • The learner will be able to identify the restrictions when calling user-defined functions from SQL expressions.
  • The learner will be able to identify the differences between a procedure and a function.
  • The learner will be able to identify the features of packages.
  • The learner will be able to identify the features of package components.
  • The learner will be able to identify the advantages of using packages.

    • Course Number:
    en_US_61134_ng