Learn how to a build a cloud-first strategyRegister Now

x
  • 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 ?
0
digs developer
Asked:
digs developer
  • 2
1 Solution
 
sdstuberCommented:
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
0
 
sdstuberCommented:
To see examples, I highly recommend reading the oracle documentation about collections

http://docs.oracle.com/cd/E11882_01/appdev.112/e25519/composites.htm#LNPLS00501

There are only 38 pages, 56 if you read through the section on records too
0

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