Oracle Database 11g: Subprograms, Packages, and Exception Handling in PL/SQL

Application developers, database designers, database administrators, forms developers, PL/SQL developers, and technical consultants

Prerequisite
The learner should have experience and knowledge with SQL, specifically the Oracle Database 11g: SQL Fundamentals I and Oracle Database 11g: SQL Fundamentals II learning

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 in PL/SQL

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