CODEWITHSUNDEEP
arraysoracle-databaseplsql
FireVortex
FireVortex

Reputation: 343

Declare dynamic array in Oracle PL/SQL

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 other times I need to store only 3 numbers

Upvotes: 3

Views: 43850

Answers (1)

Vincent Malgrat
Vincent Malgrat

Reputation: 67782

There are three types of collection in PL/SQL. Only the varrays have a fixed maximum number of elements. If you use a nested table or an associative array instead, you can add as many element as you want.

For further reading: PL/SQL Collections and Records

Upvotes: 17

Related Questions