Re: Counting Records

From: Mladen Gogala <no_at_email.here.invalid>
Date: Mon, 1 Aug 2011 16:27:45 +0000 (UTC)
Message-ID: <pan.2011.08.01.16.27.44_at_email.here.invalid>

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

> 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

Received on Mon Aug 01 2011 - 11:27:45 CDT