PL/SQL provides two composite datatypes: TABLE and RECORD. This module discusses the two composite datatypes which are TABLE and RECORD.
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
In the next lesson, you will begin to learn the structure of a PL/SQL table.
In a PL/SQL block, every constant, variable, and parameter has a data type.
PL/SQL provides predefined data types and subtypes and lets you define your own PL/SQL subtypes.
Table below lists the categories of the predefined PL/SQL data types.