Course Details

Previous Page


Oracle Database 11g: Subprograms, Packages, and Exception Handling


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



Overview/Description
To identify the steps for designing, debugging, invoking, and bundling PL/SQL subprograms, procedures and functions, and also for handling their exceptions.

Target Audience
System analysts, PL/SQL developers, forms and application developers, database administrators, technical consultants, and portal developers.

Prerequisites
Previous programming experience and knowledge of SQL

Expected Duration (hours)
2.3

Lesson Objectives

Oracle Database 11g: Subprograms, Packages, and Exception Handling

  • identify the benefits of modularized and layered subprogram design.
  • recognize the steps for creating and calling procedures and passing parameters.
  • identify the steps for handling exceptions in procedures and for dropping procedures.
  • recognize the steps for creating and invoking functions.
  • recognize the steps for using SQL Developer to debug PL/SQL subprograms.
  • identify the benefits and components of a package, and recognize the steps for creating one.
  • create a package specification and package body in a given scenario, and invoke the package's constructs.
  • Course Number:
    260273_eng