Oracle Database 11g: PL/SQL Code and Dependency Management

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
80 minutes

Description
To identify the steps for performing conditional compilation to selectively use PL/SQL code, wrapping code, and tracking dependencies.

Objective

Oracle Database 11g: PL/SQL Code and Dependency Management

  • identify the steps for selectively including PL/SQL source code by using conditional compilation, and for wrapping a PL/SQL unit.
  • recognize the steps for predicting how changing a database object affects procedures and functions by tracking procedural dependencies.
  • recognize the steps for managing remote dependencies and recompiling a PL/SQL program unit.
  • use conditional compilation, wrap PL/SQL code, and manage dependencies in a given scenario.
  • MONTHLY SUBSCRIPTION

    $129/month
     

    ANNUAL SUBSCRIPTION

    $1295/year

    Multi-license discounts available for Annual and Monthly subscriptions.