Can anybody help me.

I want to get table_names and number of rows in table
for a user.

output should be like this

table_name number_of_rows
-------------- ------------------
Dept 5
Emp 10
...
...
...
...


note : I want to get it by single query

thnx in adv.
P. Soni