Sunday 26 September 2010

Article: Collections in PL/SQL - An Introduction

My latest technical article, "Collections in PL/SQL: An Introduction", has been published online in the newsletter of the Dallas Oracle Users Group (DOUG). 

The article explains why collections are an important part of the PL/SQL language, and lists some typical uses for them. It then walks through three sample scripts showing an associative array indexed by a character string instead of an integer; using a collection to read multiple rows from the database at once with a bulk fetch; and creating a collection in which each element is an entire row from a table.

The newsletters are available to the public without membershp or registration on the site.