Results 1 to 6 of 6
  1. #1
    Join Date
    Aug 2003
    Posts
    123

    Unanswered: Oracle Nested table

    Hi,
    What is nested table, how to create and use it.

    --Jaggu

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1

    Re: Oracle Nested table

    Originally posted by jaggu
    Hi,
    What is nested table, how to create and use it.

    --Jaggu
    I'll refer you to the documentation:

    http://technet.oracle.com/docs/produ...bas.htm#458790

  3. #3
    Join Date
    Aug 2003
    Posts
    123

    Re: Oracle Nested table

    Hi Tony,
    Thanks,
    will the performance improve by using nested table.

    --jaggu

  4. #4
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1

    Re: Oracle Nested table

    Originally posted by jaggu
    Hi Tony,
    Thanks,
    will the performance improve by using nested table.

    --jaggu
    Performance of what?

  5. #5
    Join Date
    Aug 2003
    Posts
    123

    Re: Oracle Nested table

    what I ment is, by using nested table will the query be faster than joinig multiple table.

  6. #6
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1

    Re: Oracle Nested table

    Originally posted by jaggu
    what I ment is, by using nested table will the query be faster than joinig multiple table.
    No, under the covers nested tables are separate tables which get joined to the main table automatically via a hidden RAW(16) column.

    IMHO, nested tables and varrays should NOT be used to create tables in the database. You can use Object Views to create a nested table view of ordinary tables if that helps your OO application to access the data. For all other purposes, e.g. ad hoc querying and reporting, simple relational tables are far superior.

Posting Permissions

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