Oracle plsql collection types

Posted on 2014-08-07
Last Modified: 2014-08-18
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 ?
Question by:digs developer
    LVL 73

    Expert Comment

    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
    LVL 73

    Accepted Solution

    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

    Live: Real-Time Solutions, Start Here

    Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

    Join & Write a Comment

    Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
    Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
    This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.
    This video shows how to recover a database from a user managed backup

    745 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now