SELECT table_name,
TO_NUMBER
(EXTRACTVALUE
(XMLTYPE (DBMS_XMLGEN.getxml ( 'select count(*) c from '
|| table_name
)
),
'/ROWSET/ROW/C'
)
) COUNT
FROM user_tables
ORDER BY table_name;
TO_NUMBER
(EXTRACTVALUE
(XMLTYPE (DBMS_XMLGEN.getxml ( 'select count(*) c from '
|| table_name
)
),
'/ROWSET/ROW/C'
)
) COUNT
FROM user_tables
ORDER BY table_name;