Re: SQL to find out user table which count > 0!

From: Reid Lai <reidlai_at_hk.super.net>
Date: Fri, 15 Jan 1999 23:29:51 +0800
Message-ID: <369F5EEF.13110C4F@hk.super.net>

Man,

Try num_rows column from dba_tables system view.

Yeung Man wrote:

> Hi,
>
> I want to find out all user tables in our application system with
> rowcount > 0. I know I can do with the analysis and the query the dict. But,
> can I just use SQL to find them out? TIA.
>
> Best Regards,
> Man
>
> yngm_at_chowsangsang.com

--
Best Regards,

Reid Lai <reidlai_at_hk.super.net>
Oracle 7.3 Certified Database Administrator (OCP)

---

The above opinions are mine and do not represent any official standpoints of my employer Received on Fri Jan 15 1999 - 09:29:51 CST