Oracle

Front 1

Oracle - Vaarys

Back 1

Varrays are a good choice when the number of elements is known in advance, and when the elements are usually all accessed in sequence.

When stored in the database, varrays retain their ordering and subscripts.

TYPE type_name IS {VARRAY | VARYING ARRAY} (size_limit)
OF element_type [NOT NULL];

Front 2

Oracle Nested Table

Back 2

Nested tables can be sparse: you can delete arbitrary elements,You cannot rely on the order and subscripts of a nested table remaining stable as the table is stored and retrieved

TYPE type_name IS TABLE OF element_type [NOT NULL];

Front 3

test

Back 3

1

Front 4

test2

Back 4

2