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

On Nov 26, 10:11 pm, Mark D Powell <Mark.Pow..._at_eds.com> wrote:
> On Nov 26, 11:21 am, noelloen <noel...._at_gmail.com> wrote:
>
> > Hi
>
> > How can i display user tables that are not empty using PLSQL
> > developer? or
> > How can i display user tables that are empty using PLSQLdeveloper?
>
> > 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 --

Hi There

Whatever information Mark has given you is nice.

Take a look at the information given here also. num_rows give approx result only if stats are upto date. So it depends upon your requirement as stated at followin link

http://groups.google.co.in/group/comp.databases.oracle.tools/browse_thread/thread/b921a53097ecf9c2/bc8a7f5e147b6473?hl=en&lnk=st&q=num_rows+give+wrong+result+oracle#bc8a7f5e147b6473

With Warm regards
Jatinder Singh
http://jatindersingh.blogspot.com Received on Tue Nov 27 2007 - 00:52:46 CST