Results 1 to 5 of 5
  1. #1
    Join Date
    Mar 2017
    Posts
    1

    Unanswered: Why using nested tables rather than REFs ?

    Hello,

    What are the nested tables used for ?

    I think I understand both nested table and ref concepts.

    However, I can't figure out the benefits of the nested vs the ref.

    Is there better use cases for both ? How to know ?

    Because I personally find the pointer system of ref more clear and organized.


    Thank you !
    Last edited by JackPoteYes; 03-15-17 at 10:17.

  2. #2
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,113
    Provided Answers: 5
    What do you call a "REF"? What is it? I've been working with Oracle for 20+ years, but I'm not familiar with this term.

    Anyway, I can share some thoughts about nested tables. Do I know they exist? Yes. Do I use them? No. Why? I see no benefit.

  3. #3
    Join Date
    Nov 2003
    Posts
    2,988
    Provided Answers: 23
    Quote Originally Posted by Littlefoot View Post
    What do you call a "REF"? What is it? I've been working with Oracle for 20+ years, but I'm not familiar with this term.
    https://docs.oracle.com/database/121...2.htm#i1015744

    But I agree: I find both concepts pretty useless. I once played around with nested tables (as a replacement for real arrays the way Postgres supports) but they turned out to be horribly slow and rather complicated to use (especially through Java/JDBC).

    I think both features come from the "object relational" part that was introduced in Oracle 8, but I don't think any those concepts is of real value.
    I will not read nor answer questions where the SQL code is messy and not formatted properly using [code] tags: http://www.dbforums.com/misc.php?do=bbcode#code

    Tips for good questions:

    http://tkyte.blogspot.de/2005/06/how...questions.html
    http://wiki.postgresql.org/wiki/SlowQueryQuestions
    http://catb.org/esr/faqs/smart-questions.html

  4. #4
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,520
    I never saw the point of using nested tables. They are just over complicated to use. I always use daughter tables to hold the data.
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

  5. #5
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,113
    Provided Answers: 5
    Shammat, thank you for the REF link. It appears that I should be working harder with Oracle, after all.

Tags for this Thread

Posting Permissions

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