Re: print table name and the number of rows in it

Sreelal wrote:
> i want to print all the tables names owned by a user along with their
> number of rows...
>
> give me query
> thankz
>

select table_name, num_rows
from user_tables
order by 1;

gives tables of the current user.

--
Arto Viitanen
Espoo, Finland