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

This course is included in our On-demand training solution.

Overview

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

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

80 min.

Course Objectives

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



     

    NEED HELP OR NOT SURE?