Re: Count all records in all tables

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Fri, 14 Apr 2006 06:52:11 +0200
Message-ID: <443f2a7a$0$3475$626a54ce@news.free.fr>

"Mark D Powell" <Mark.Powell_at_eds.com> a écrit dans le message de news: 1144974578.310134.295400_at_g10g2000cwb.googlegroups.com...
| Maybe the following technique for generating and executing select
| count(*) for any desired set of tables might be of use here:
|
| Is there a simple way to produce a report of all tables in the database
| with current number of rows ?

Yes, the scripts i posted don't use PL/SQL, just SQL (and SQL*Plus). :)

Regards
Michel Cadot

| http://www.jlcomp.demon.co.uk/faq/count_all_rows.html
|
| HTH -- Mark D Powell --
|
Received on Thu Apr 13 2006 - 23:52:11 CDT