Re: SELECT Statement help required

James Petts wrote:
>
> I'm trying to write a SELECT statement which will return the
> number of rows in each of a set of tables selected by owner
> from DBA_TABLES.
>

I use this SQL to select the number of rows from USER_TABLES :

column table_name format A16
column num_rows format 999,999,999 heading 'Rows' ; column blocks format 999,999 heading 'Blocks' ; column empty_blocks format 999,999 heading 'Empty Blocks' ; compute sum of empty_blocks on report
compute sum of blocks on report
break on report

select table_name, num_rows, blocks, empty_blocks, avg_row_len from user_tables
order by table_name; Received on Thu Jul 24 1997 - 00:00:00 CDT