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


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
Application developers, database designers, database administrators, forms developers, PL/SQL developers, and technical consultants

Prerequisites
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 (hours)
1.7

Lesson Objectives

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.

    • Course Number:
    257817_eng