Re: Count(*)ing nested tables


"--CELKO--" <jcelko212@xxxxxxxxxxxxx> wrote:

>Just what it sounds like. Instead of having nice atomic 1NF columns,
>you can stuff another table into a row. Example, you have a personnel
>table with a table for dependents stuffed inside each employee's row.
>Inside the dependents, you can stuff their pets, etc. ARRRGH!


I've seen the beast!

A "table" with 35000 (that's 35K) rows. I still wake up with cold
sweats thinking about it...


Paul...


--

plinehan __at__ yahoo __dot__ __com__

XP Pro, SP 2,

Oracle, 9.2.0.1.0 (Enterprise Ed.)
Interbase 6.0.1.0;

When asking database related questions, please give other posters
some clues, like operating system, version of db being used and DDL.
The exact text and/or number of error messages is useful (!= "it didn't work!").
Thanks.

Furthermore, as a courtesy to those who spend
time analysing and attempting to help, please
do not top post.
.

Relevant Pages

  • Re: BOOKS ON DATA QUALITY?
    ... Oracle, 9.2.0.1.0 (Enterprise Ed.) ... Interbase 6.0.1.0; ... When asking database related questions, ...
    (comp.databases)
  • Re: Problem with some simple PL/SQL.
    ... Rene Nyffenegger wrote: ... Oracle, 9.2.0.1.0 (Enterprise Ed.) ... When asking database related questions, ...
    (comp.databases.oracle.server)