Re: SQL99 - Nested Tables

Darren,

> I was mainly interested because of the simplicity it seems to add for
> implementing an application using the database. While those accustomed
> to writing SQL queries using joins and keys might prefer it for many
> understandable reasons, there is something to be said for
> multidimensional data structures. It would be like if you _had_ to have
> multiple arrays to store information in C instead of using a
> multidimensional array. I'm open to debate on the subject as I'd love to
> be convinced that Oracle is wrong.

Ooops. Our discussion somehow got shifted off list. Suffice it to say
that not everyone agrees with me.

> I think the XML features are
> important and I'd be more suited writing something more straight forward
> versus re-inventing the wheel. I brought it up for debate, because I
> thought it was something that should be thought about.

Yes, I just don't see how nested tables relate to XML.

--
--Josh

Josh Berkus
Aglio Database Solutions
San Francisco