How do we use arrays in PL/SQL?How to print this pattern.?

Question

A1,A2,A3,A4,A5,A6,A7,A8,A9,A10

B1,B2,B3,B4,B5,B6,B7,B8,B9,B10
.
.
.
Z1,Z2,Z3,Z4,Z5,Z6,Z7,Z8,Z9,Z10

Answer 1

The trick here is that they don't call them arrays! Kinda cooky isn't it? They call them collections (which in most languages means an array of various, possibly different, object types). I have provided a few links below to get you started since there are three basic types of "collections" that PLSQL can handle.

1) Nested tables
2) Varrays
3) Index-by tables

Varrays and nested tables also need to specify a constructor so I have put a link in there for that as well.

Hope these links help you out.