SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Count number rows in multiple tables from one query

476330Mar 31 2006 — edited Mar 31 2006

Hi

I was wondering if its possible to have a single query return the number of lines in multiple tables, for example i have the tables

foo1
pk_foo1

and

foo2
pk_foo2

They are not joined together by any contraints. So the pseudo code for the query would be something like

SELECT numrows(pk_foo1), numrows(pk_foo2) FROM foo1, foo2

Thanks!

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 28 2006

Added on Mar 31 2006

5 comments

665 views