Lesson 1
Working with composite datatypes
PL/SQL provides two composite datatypes: TABLE and RECORD. This module discusses the two composite datatypes which are TABLE and RECORD.
Module objectives
By the end of this module, you will know how to:
-
Describe the structure of a PL/SQL table
-
Define and populate a PL/SQL record
- Use %Type and %RowType attributes to manipulate data