Oracle Database 11g: Using Data Types, INDEX BY Tables, and Cursors

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

Description
To recognize ways to create user-defined PL/SQL records and INDEX BY tables, and identify the steps for declaring and controlling explicit cursors and cursors with parameters.

Objective

Oracle Database 11g: Using Data Types, INDEX BY Tables, and Cursors

  • recognize the steps for creating user-defined PL/SQL records and records with the %ROWTYPE attribute.
  • recognize the steps for creating an INDEX BY table and table of records, and identify the uses of nested tables and VARRAYs.
  • define, create, and use INDEX BY tables and a PL/SQL record in a given scenario.
  • identify the steps for declaring and controlling explicit cursors, and for writing FOR loops to fetch data from them.
  • recognize the steps for declaring and using cursors with parameters, locking rows, and referencing the current row in an explicit cursor.
  • MONTHLY SUBSCRIPTION

    $129/month
     

    ANNUAL SUBSCRIPTION

    $1295/year

    Multi-license discounts available for Annual and Monthly subscriptions.