generate dynamically the number of records per table in a schema

Hi,

I  was wondering if there is  a way to generate dynamically the number of records per table for a given scehma.

I need to get the input in the format :

table name , row_count

xxx               100

yyy               200

...................

....................

I have found in various forums that xml query can be used for that . I have used the below successfully  to pick number of records in each of the table's partition, but I am wondering if there is another way without using xml:

INSERT INTO xxx(PARTITION_NAME,ROWS_IN_SOURCE)SELECT

PARTITION_NAME,to_number(extractvalue(xmltype(dbms_xmlgen.getxml('select count(*) X from '