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


Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number


Overview/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.

Target Audience
System analysts, PL/SQL developers, forms and application developers, database administrators, technical consultants, and portal developers.

Prerequisites
Previous programming experience and knowledge of SQL

Expected Duration (hours)
1.7

Lesson Objectives

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.

    • Course Number:
    260271_eng