1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

purpose of pl/sql tables.

Discussion in 'SQL PL/SQL' started by devie, Sep 10, 2009.

  1. devie

    devie Guest

    Hello,
    Could anyone one please tell me the purpose of using pl/sql tables such as index by tables, nested tables and varray.
    At what scenario we decide "okey.. Using pl/sql table concepts here is a good choice"..

    I am not actually looking for the syntax and all as plenty of them available in may websites. I need to know why we have to use and what are the advantages? and what could be the better "instead of" option?

    Thanks.
     
  2. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,345
    Likes Received:
    347
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    Google is your friend:

    http://www.google.com/search?hl=en&source=hp&q=pl/sql+tables&aq=f&oq=&aqi=g10

    The fourth entry on that page is one which will probably answer your questions.
     
  3. UnixGuru

    UnixGuru Active Member

    Messages:
    28
    Likes Received:
    1
    Trophy Points:
    90
    Well it can improve performance if you are using PL/SQL tables for data you access frequently in your program. It's just like why does any common programming language use an array?