Actually, in fact there are such things (and why was this 
marked as a duplicate?)

[download]
http://download-west.oracle.com/otndoc/oracle9i/901_doc/appdev.901/a88878/adobjdes.htm#441615 

While oracle is in fact at it's core a relational database structure, 
oracle8i and above provide some nifty objectish approaches
to both storing and recovering data in more complex structures.

Think of the fields represented here with *_NT as being tables
within the row elements of the interface table.  In perl you
would call this strucrure a multi dimensional hash, where the keys
*_NT point to embedded hashes as their values.

The upshot of doing something like this is that when you are
dealing with many tables which have extremely large counts of
row data, you do not have to do explicit joins to find the
data you wish to retrieve, thus making things run ALOT faster 
by avoiding the need to create a large cartesian product and
then eliminating rows before retrieving your data.

I cant possibly have been the first person to try this. <:)

   --perlboy

[download]

In reply to Re: Re: Re: Nested table structures in Oracle & DBI by perlboy26sf
in thread Nested table structures in Oracle & DBI by perlboy26sf

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.