Oracle Programming with PL/SQL Collections, Page 2 The Varray is
short for Variable Array. A Varray stores elements of the same
type in the order in which they are added. The number of
elements in a Varray must be known at the time of its
declaration. In other words, a Varray has a fixed lower and
upper bounds, making it most similar to collection types from
other programming languages. Once it is created and populated,
each element can be accessed by a numeric index. The following
statements declare, and then populate, a Varray that will
contain 4 elements of the same type as the column genre_name in
table book_genre: DECLARE TYPE genres IS VARRAY(4) OF
book_genre.genre_name%TYPE; Fiction_genres genres; BEGIN
fiction_genres := genres('MYSTERY','SUSPENSE',
'ROMANCE','HORROR'); END; We could have declared genres to be of
type VARCHAR2(30) because all values here are text. However, in
keeping with good Oracle programming practices, you should
always prefer to declare variables that are based on table
columns wi