dbTalk Databases Forums  

Counting Rows

comp.databases.oracle.misc comp.databases.oracle.misc


Discuss Counting Rows in the comp.databases.oracle.misc forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
The Magnet
 
Posts: n/a

Default Counting Rows - 08-01-2011 , 08:44 AM






Hi,

I have a table with 3 nested tables in it, and of course x number of
records in each nested table.

I'm looking to include with my query output the number of rows
selected from each nested table. Can this be done?

I may have 100 rows in the nested table, but only 10 were chosen as
part of the result set....

Reply With Quote
  #2  
Old   
Michel Cadot
 
Posts: n/a

Default Re: Counting Rows - 08-01-2011 , 10:13 AM






"The Magnet" <art (AT) unsu (DOT) com> a écrit dans le message de news: dcb134ce-a957-4643-900f-8210e3f9de89...oglegroups.com...
Quote:
Hi,

I have a table with 3 nested tables in it, and of course x number of
records in each nested table.

I'm looking to include with my query output the number of rows
selected from each nested table. Can this be done?

I may have 100 rows in the nested table, but only 10 were chosen as
part of the result set....
Test case ?

Regards
Michel

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.