Oracle Database 11g: Managing PL/SQL Code and Dependencies

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
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: Managing PL/SQL Code and Dependencies

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