Querying the data from varrays:

Data can be selected as a complete list from the table holding varrays. An Individual manipulation cannot be done in SQL. Also, although performing updation, even if one single value has to be updated the overall collection has to be specified.

The Example given below shows how to select and update records. Although issuing SELECT statement,

SELECT * FROM prods;

Displays,

PNO

-------

RATE

--------

2

PRICE_LIST(12, 34, 56)

1

PRICE_LIST(12, 34, 56, 78)

Selecting can be completed only as a collection unit.