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

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

Prerequisite
Previous programming experience and knowledge of SQL

Expected Duration
140 minutes

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

Objective

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.
  • MONTHLY SUBSCRIPTION

    $129/month
     

    ANNUAL SUBSCRIPTION

    $1295/year

    Multi-license discounts available for Annual and Monthly subscriptions.