asked on

Collections

Hi,

Why we have 3 types of collections(Index-by-tables,Nested tables and V-Arrays)?

Which collection we need to use for different sinarios?

Please provide examples.

ASKER CERTIFIED SOLUTION

slightwv (䄆 Netminder)

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

pms_reddy1

ASKER

Is there any max size applicable for the any/all of the collection types? If so, what is the max size?

slightwv (䄆 Netminder)

It literally took 5 seconds to open the doc link above and ctrl-f to search for limit:

Number of Elements

If the number of elements is specified, it is the maximum number of elements in the collection. If the number of elements is unspecified, the maximum number of elements in the collection is the upper limit of the index type.

pms_reddy1

ASKER

I don't think you undersatnd my question correctly.
My question is what is the maximum number of records one collection can hold?
Ex: varray(x),In this what is the x's maximum size we can specify,1000000 or 10000000 ...
Just I have taken the varray ex , In the same way I am looking for the all the collection types.

and I don't like some of your comments like:
>>This sounds a little like homework or an exam question.
>>It literally took 5 seconds to open the doc link above and ctrl-f to search for limit:

If want to answer the readers questions It will be well and good,If you don't want to answer just leave it.Because of this type of comments,people may get bad impression on EE..

SOLUTION

slightwv (䄆 Netminder)

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial