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.