<div>
you can query from nested tables, you can use them in sql statements<br />
<br />
varray and associative arrays (formal name for index-by tables) can only be used in pl/sql.<br />
<br />
varray has a maximum size associated with it, the others can grow dynamically and unbounded<br />
<br />
associative arrays can be indexed by string values or numeric<br />
whereas nested tables and varray are only numeric
</div>


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

<div>
<div class="content wysiwyg-content">
When to used varray , Index by table nested by table on which scenario?<br />
<br />
Which is the best in between Index by table and nested by table &nbsp;and why ?<br />
<br />
Could you please explain me with example ?
</div>
</div>


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 ?

Oracle plsql collection types

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.