O'Reilly logo

Oracle SQL and PL/SQL Handbook: A Guide for Data Administrators, Developers, and Business Analysts by John Adolph Palinski

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required