Re: Help with a SQL statement

From: Tom Sager <tom.sager_at_lgeenergy.com>
Date: Tue, 15 Sep 1998 15:51:35 -0400
Message-ID: <WtzL1.1370$rm3.1639907355@news.ntr.net>

How about:

select owner, table_name, num_rows from dba_tables

you must rely on statistics gathered from an analyze, but it's cheaper than performing a select count(*) on every table.

stuco_at_mailcity.com wrote in message <6tmepg$l5g$1_at_nnrp1.dejanews.com>...
>I would like to issue one SQL or PL/SQL statement that would gather
>table_names and their respective row counts. How can this be done?? I know
>that I can write a SQL statement to create a bunch of SQL calls, but I
would
>rather only make one call to the database to save on overhead.
>
>thanks ever so much!
>
>Stuart Cowen
>Paladin Consulting - Dallas
>
>-----== Posted via Deja News, The Leader in Internet Discussion ==-----
>http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
Received on Tue Sep 15 1998 - 14:51:35 CDT