create tentr3

SELECT
t.table_name,
TO_NUMBER(EXTRACTVALUE(
XMLTYPE(DBMS_XMLGEN.GETXML(
'SELECT COUNT(*) AS c FROM ' || USER || '.' || t.table_name
)),
'/ROWSET/ROW/C'
)) AS row_count
FROM
user_tables t
ORDER BY
t.table_name;