Oracle plsql collection types

When to used varray , Index by table nested by table on which scenario?

Which is the best in between Index by table and nested by table  and why ?

Could you please explain me with example ?
digs developerAsked:
Who is Participating?
To see examples, I highly recommend reading the oracle documentation about collections

There are only 38 pages, 56 if you read through the section on records too
you can query from nested tables, you can use them in sql statements

varray and associative arrays (formal name for index-by tables) can only be used in pl/sql.

varray has a maximum size associated with it, the others can grow dynamically and unbounded

associative arrays can be indexed by string values or numeric
whereas nested tables and varray are only numeric
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.