Re: display user tables that are not empty using PL SQL

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: Mon, 26 Nov 2007 09:11:40 -0800 (PST)
Message-ID: <45fd32e9-47c9-473d-9829-e1b15edc1738@w34g2000hsg.googlegroups.com>

On Nov 26, 11:21 am, noelloen <noel...._at_gmail.com> wrote:
> Hi
>
> How can i display user tables that are not empty using PL SQL
> developer? or
> How can i display user tables that are empty using PL SQL developer?
>
> thanks

Perhaps the following articles will be of help to you:

Is there a simple way to produce a report of all tables in the database with current number of rows ? http://www.jlcomp.demon.co.uk/faq/count_all_rows.html

How do I find information about a database object: table, index, constraint, view, etc... in Oracle ? http://www.jlcomp.demon.co.uk/faq/object_info.html

HTH -- Mark D Powell -- Received on Mon Nov 26 2007 - 11:11:40 CST