Re: SQL and Oracle

I think you'll find that this is the easiest way:

SELECT table_name
FROM dba_tables
WHERE num_rows > 0
AND owner='owner_name';

Sarah

Pavan wrote:

> How can I list all the tables in a Users Schema, which does contain any
> records in them using a single SQL Query or a Statement.
>
> * Sent from RemarQ http://www.remarq.com The Internet's Discussion Network *
> The fastest and easiest way to search and participate in Usenet - Free!
Received on Wed Jan 12 2000 - 02:55:49 CST