Oracle plsql collection types

digs developer
digs developer used Ask the Experts™
on
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 ?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Most Valuable Expert 2011
Top Expert 2012

Commented:
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
Most Valuable Expert 2011
Top Expert 2012
Commented:
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

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial