Oracle Database 11g: Using Data Types, INDEX BY Tables, and Cursors in PL/SQL

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
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 in PL/SQL

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