Re: sql challenge

From: Izabella <Izabella.Urbanek_at_afp.gov.au>
Date: Tue, 2 Mar 1999 13:59:04 +1100
Message-ID: <7bfka8$mj$1@platinum.sge.net>

You could analyze all your tables and then use NUM_ROWS column in ALL_TABLES

... where owner = 'SIMON'

and num_rows > 10

Naushi Hussain wrote in message <36DB1D57.434DD423_at_Alliedsignal.com>...
>I want to get a row count for only those tables in my tablespace that
>have more than 10 rows. There are 600 tables in my tablespace called
>'SIMON'. I dont want to write 600 select count(*) statements. How will I
>do it then to avoid all this typing. I know I can use (select 'count(*)
>from ', table_name from all_tables where owner = 'SIMON'). but how do I
>select only those tables that have more than 10 rows.
>
>Any attempt will be appreciated.
>
Received on Mon Mar 01 1999 - 20:59:04 CST