Ger row_count of all the tables of a schema - oracle database script

Ger row_count of all the tables of a schema - Oracle Database Script.

SELECT TABLE_NAME,
       to_number(extractvalue(dbms_xmlgen.getXMLtype('select /*+ PARALLEL(8) */ count(*) cnt from "&&SCHEMA_NAME".'||TABLE_NAME), '/ROWSET/ROW/CNT')) rows_in_table
FROM dba_TABLES
WHERE OWNER='&&SCHEMA_NAME';