Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: display user tables that are not empty using PL SQL
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
![]() |
![]() |