Oracle Database 11g: Getting Started With PL/SQL

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

Description
To identify the steps for getting started with PL/SQL, recognizing the benefits of the available tools, creating basic statements, declaring variables, testing code, and adhering to scoping and nesting rules.

Objective

Oracle Database 11g: Getting Started With PL/SQL

  • recognize the features and capabilities of SQL Developer, SQL*Plus, and JDeveloper.
  • identify the features and benefits of PL/SQL and identify the steps for building basic PL/SQL blocks.
  • identify the steps for declaring and initializing PL/SQL variables.
  • identify the uses of different PL/SQL data types, the %TYPE attribute, and BIND variables.
  • identify the steps for constructing executable statements using various PL/SQL block elements.
  • evaluate a block of PL/SQL code with respect to scoping and nesting rules, and write and test PL/SQL blocks.
  • MONTHLY SUBSCRIPTION

    $129/month
     

    ANNUAL SUBSCRIPTION

    $1295/year

    Multi-license discounts available for Annual and Monthly subscriptions.