SELECTs from Nested Tables within Nested Tables.

From: Walt Borders <borderw_at_ironhilltech.com>
Date: 5 Oct 2001 06:10:02 -0700
Message-ID: <5bd8e607.0110050510.5e81048c_at_posting.google.com>


Hi,

I've built the example in Oracle's documentation, Oracle8i Application Developer's Guide - Object-Relational Features: Chapter 5, Design Consideration for Oracle Objects, (Nesting Collections within other Collections). I've also built a number of other project Object tables that have nested tables within nested tables.

SELECTing from the objects table is no problem. First flatten the nested table column then dereference that column making sure to use the correct column name of "column_value". Works fine.

For multiple nested columns within a single object table and for the bottom rows of the deepest nesting table; the return from a SELECT displays like a Cartesian Product. I've tried key values through every nested definition and that does not get rid of the extra associations.

Any examples of using SELECTs in the context mulitple level nesting within either nested tables or varrays would be much appreciated.

Thank you,
Walt Borders Received on Fri Oct 05 2001 - 15:10:02 CEST

Original text of this message