Re: all table names with row counts?

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Wed, 27 Jan 1999 19:29:22 -0000
Message-ID: <917465320.12724.1.nnrp-03.9e984b29@news.demon.co.uk>

Vadim Tropasko wrote in message <36AF6683.8816B009_at_us.oracle.com>...
>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.
>

Does this also preclude using a procedure that returns a REF CURSOR so that you can use SQL*Plus to do the format and presentation side of the report ?

Jonathan Lewis
Yet another Oracle-related web site: www.jlcomp.demon.co.uk Received on Wed Jan 27 1999 - 13:29:22 CST