Using Composite Data Types

Overview/Description
To identify the benefits associated with records and collections, declare and initialize nested tables and VARRAYs, and create and reference an INDEX BY table and table of records

Target Audience
Database administrators, application developers, and database operators

Prerequisites
Familiarity with Oracle Database 10g database technology; an understanding of the basic concepts of relational databases and the SQL programming language; ability to write queries against single and multiple tables, manipulate data in tables, create database objects, and query metadata

Expected Duration (hours)
2.0

Lesson Objectives

Using Composite Data Types

identify the benefits associated with records and collections in PL/SQL.

create and populate a user-defined record in PL/SQL.

create a record using the %ROWTYPE attribute and use it to insert and update a row.

create a record and use it to update a table.

create and reference an INDEX BY table and table of records.

declare and initialize nested tables and VARRAYs.

create and reference a table in PL/SQL.