PL/SQL by Example / Composite Data Types
The topic of structures capable of holding multiple values is somewhat extensive due to the division of the Oracle database into an SQL part and a procedural PL/SQL extension. Also, individual database versions bring slight differences in the use of given structures.