Oracle で各テーブルの正確なレコード数を取得する

[Tobotobo]

SELECT
    TABLE_NAME,
    TO_NUMBER(
        EXTRACTVALUE(
            XMLTYPE(
                DBMS_XMLGEN.GETXML('SELECT COUNT(*) C FROM "' || TABLE_NAME || '"')
            ),
            '/ROWSET/ROW/C'
        )
    ) COUNT
FROM
    USER_TABLES
WHERE
    TABLE_NAME NOT LIKE 'BIN$%'
    AND (
        IOT_TYPE != 'IOT_OVERFLOW'
        OR IOT_TYPE IS NULL
    )
ORDER BY
    TABLE_NAME;

※整形なし

SELECT TABLE_NAME, TO_NUMBER(EXTRACTVALUE(XMLTYPE(DBMS_XMLGEN.GETXML('SELECT COUNT(*) C FROM "'||TABLE_NAME||'"')), '/ROWSET/ROW/C')) COUNT FROM USER_TABLES WHERE TABLE_NAME NOT LIKE 'BIN$%' AND (IOT_TYPE != 'IOT_OVERFLOW' OR IOT_TYPE IS NULL) ORDER BY TABLE_NAME;