Re: SQL EXPERTS ONLY

Simon Stow wrote:
>
> 1. in user_tables there is a NUM_ROWS column so:
>
> select table_name, num_rows from user_tables;
>
> looks like it oughta work, but doesn't, at least not on my database -
> num_rows is null for all tables - maybe it requires something else to be
> switched on?

You can fill these fields by analyze table name_of_table_that you want. Received on Thu Aug 01 1996 - 00:00:00 CEST