PL/SQL Records and Arrays
PL/SQL also allows the developer to define and use array-type objects within a code block. An array is a predefined series of value holders, cells, or rows of cells that have the same data type(s). A unique number called an integer identifier distinguishes the different rows. In PL/SQL the array-type object is called a PL/SQL table. There are some differences between a typical array and a PL/SQL table record:
Each table row consists of at least two columns: The integer identifier and the corresponding cell(s). Arrays can consist of only one column.
You do not specify the maximum number of rows in the PL/SQL table when it is defined. Arrays require the maximum rows to be defined.
There is no limit to the number of rows ...
Get Oracle SQL and PL/SQL Handbook: A Guide for Data Administrators, Developers, and Business Analysts now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
