Oracle Database 11g: PL/SQL Variables, Attributes, and Executable Statements

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

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: PL/SQL Variables, Attributes, and Executable Statements

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