Learn how to a build a cloud-first strategyRegister Now

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 283
  • Last Modified:

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 developer
digs developer
  • 2
1 Solution
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
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

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now