Oracle Database 11g: Using DML, DDL, Cursors, Control Structures, and Loops

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

Description
To identify the steps for using PL/SQL to manipulate data, control transactions, determine the outcome of statements, and create loops and conditional control structures.

Objective

Oracle Database 11g: Using DML, DDL, Cursors, Control Structures, and Loops

  • recognize the steps for performing basic data manipulation and transaction control in PL/SQL, and for determining the outcome of SQL statements.
  • identify the steps for writing control structures, such as IF statements and CASE expressions, in a PL/SQL block.
  • recognize the steps for writing and identifying loop statements.
  • create PL/SQL blocks that incorporate loops and conditional control structures.
  • MONTHLY SUBSCRIPTION

    $129/month
     

    ANNUAL SUBSCRIPTION

    $1295/year

    Multi-license discounts available for Annual and Monthly subscriptions.