Declare dynamic array in Oracle PL / SQL

Question

Is there an easy way to declare a dynamic array in Oracle PL / SQL?

I need to use an array that can contain 100,000 numbers, and at other times I need to store only 3 numbers

Answer 1

There are three types of collections in PL / SQL. Only varrays has a fixed maximum number of elements. If instead you use a nested table or PL / SQL Collections and Entries