Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004
    Posts
    3

    What is the difference btw Varray and Nested Tables

    Hi

    I am totally new to the object relational database. I am currently reading some features of Oracle 9i and don't understand the difference between varray and nested tables. Can anyone please explain what situation we should use varray and what circumstance we should use nested tables?

    Thanx

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171

    Re: What is the difference btw Varray and Nested Tables

    (This question belongs in the Oracle forum, not here.)

    A Varray is an ordered array (elements are indexed 1,2,3,...), which is physically stored in the table it belongs to.

    A Nested Table is actually a separate physical table but made to look like it is nested within the table it belongs to. There is no implicit ordering (no index 1,2,3,... defined), rather you reference the data by key values.

    I would never use either in the database as they add a lot of SQL complexity for no gain. In a PL/SQL program you might use a nested table so that you can select from an in-memory array as if it were a real table.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •