Counting Records

#1

Hi,

I have a table with 3 nested tables in it. I want to be able to
return the number of rows retrieved from each nested table in my
result set.

This cannot be just a simple count, as if the nested tables have 100
rows each, but the result set selects 10 from nested table 1, 50 from
nested table 2 & 25 from nested table 3.

Is there a way for me to get this count?

#2

On Mon, 01 Aug 2011 08:16:08 -0700, The Magnet wrote:

Quote:

Hi,

I have a table with 3 nested tables in it. I want to be able to return
the number of rows retrieved from each nested table in my result set.

This cannot be just a simple count, as if the nested tables have 100
rows each, but the result set selects 10 from nested table 1, 50 from
nested table 2 & 25 from nested table 3.

Is there a way for me to get this count?

Yup. Truncate all 3 tables and do "select 0 from dual".

--
http://mgogala.byethost5.com

#3

"The Magnet" <art (AT) unsu (DOT) com> a écrit dans le message de news: 93486fc1-ada5-4c6e-8ca7-a66c55ee1003...oglegroups.com...

Quote:

Hi,

I have a table with 3 nested tables in it. I want to be able to
return the number of rows retrieved from each nested table in my
result set.

This cannot be just a simple count, as if the nested tables have 100
rows each, but the result set selects 10 from nested table 1, 50 from
nested table 2 & 25 from nested table 3.

Is there a way for me to get this count?

Test case ?

Regards
Michel

#4

The Magnet <art (AT) unsu (DOT) com> wrote in news:93486fc1-ada5-4c6e-8ca7-
a66c55ee1003 (AT) eb9g2000vbb (DOT) googlegroups.com:

Quote:

Hi,

I have a table with 3 nested tables in it. I want to be able to
return the number of rows retrieved from each nested table in my
result set.

This cannot be just a simple count, as if the nested tables have 100
rows each, but the result set selects 10 from nested table 1, 50 from
nested table 2 & 25 from nested table 3.

Is there a way for me to get this count?

Redesign to properly normalised parent/child tables.

--
Jeroen

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Counting Records

comp.databases.oracle.server comp.databases.oracle.server

Counting Records - 08-01-2011 , 10:16 AM

Re: Counting Records - 08-01-2011 , 11:27 AM

Re: Counting Records - 08-01-2011 , 03:01 PM

Re: Counting Records - 08-01-2011 , 03:52 PM