Sets and arrays

Rowsets are very similar to arrays in many ways, but they mainly differ in how you can use them. For most data manipulations, you want to use rowsets, as the SQL language is designed to deal with them. Arrays, however, are most useful for static storage. They are more complicated for client applications to use than rowsets, with usability features missing such as no simple and straightforward built-in way to iterate over them.