From: "Steve McDaniels" <steve.mcdaniels@sierra.com>
Newsgroups: comp.databases.oracle.server
Subject: Re: Nested Tables?
Date: Fri, 2 Feb 2001 12:00:26 -0800
Organization: Sierra On-Line, Inc.
Lines: 28
Message-ID: <95f3jd$3i$1@spiney.sierra.com>
References: <95ek4v$2ic$1@nnrp1.deja.com>
NNTP-Posting-Host: 172.20.13.115
X-Trace: spiney.sierra.com 981143981 114 172.20.13.115 (2 Feb 2001 19:59:41 GMT)
X-Complaints-To: usenet@spiney.sierra.com
NNTP-Posting-Date: 2 Feb 2001 19:59:41 GMT
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4133.2400
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400


Nested Tables:

Assume you have a db which holds consumer info, such as
name, address, telephone, email address, and some product info.

A real simple example would be for handling of multiple telephone numbers.

That is, you might have a name (probably first, middle, last),
an address (like address1, address2, city, state, postal code [for U.S.
consumers]),
and telephone(s), perhaps a work phone, daytime phone, nighttime phone, etc.

One might wish to store telephones as part of the name record using a
"sub-table" of
telephone numbers [and associated "type" as work, home, etc.]

<jdorlon@my-deja.com> wrote in message news:95ek4v$2ic$1@nnrp1.deja.com...
> Can anyone describe a scenario of when nested tables would be desired?
> They just seem so complicated to me that they are not worth the
> effort!  Am I missing something?
>
> Thanks!
>
>
> Sent via Deja.com
> http://www.deja.com/