Re: counting rows in all_tables ???????

From: Mike Burke <mike.burke_at_dial.pipex.com>
Date: 1997/07/23
Message-ID: <33D67C76.4C20@dial.pipex.com>#1/1

Erik,

One way is to write some sql that will write some sql...

e.g.

sql> describe all_tables

sql> spool count.sql
sql> select ' select count(*) from ' || table_owner || '.' table_name || ';'

	from all_tables
			order by owner , table_name;

sql> spool off
sql> @count.sql

I may not have the correct column names but I hope you get the idea. Anyway it is a good technique to develop.

Mike Received on Wed Jul 23 1997 - 00:00:00 CDT