Re: all table names with row counts?

From: Vadim Tropasko <vtropash_at_us.oracle.com>
Date: Wed, 27 Jan 1999 12:50:02 -0800
Message-ID: <36AF7BFA.BE872857@us.oracle.com>

This query doesn't seem to be executable in pure SQL (please, correct me if I'm wrong), because
any relational operation involves only limited number of tables. It cannot query arbitrarily many
tables like 'all_tables' in this case.

Vadim Tropasko wrote:

> I want to perform query like this
>
> select table_name, (select count(*) from table_name) from all_tables
>
> but cannot fugure out how to build join correctly. Any ideas?
>
> No procedural solution, please.
Received on Wed Jan 27 1999 - 14:50:02 CST