O'Reilly logo

Oracle® Web Application Programming for PL/SQL® Developers by Benjamin Rosenzweig, Solomon Morse, Melanie Caffrey, Susan Boardman

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

Unit 9.4. PL/SQL Tables

PL/SQL tables are Oracle’s version of an array. You can think of an array as a list, similar to an Excel worksheet with only two columns. In the same way you refer to a cell in the Excel worksheet by its column letter and row number, each element of a PL/SQL table is referenced by its index number. In this chapter, you review how to make use of PL/SQL tables.

PL/SQL Table Basics

PL/SQL tables are PL/SQL’s way of providing arrays. Arrays are like temporary tables in memory and thus are processed very quickly. It is important for you to realize they are not database tables, and DML statements cannot be issued against a PL/SQL table. This type of table is indexed by a binary integer counter (it cannot be indexed by another ...

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