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

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.