Wednesday, August 13, 2025

Oracle DB All Table rows count

SET SERVEROUTPUT ON; 

DECLARE

    v_table_name VARCHAR2(128);

    v_row_count NUMBER;

BEGIN

    DBMS_OUTPUT.PUT_LINE('TableName#RowsCount');

--owner is schema name

    FOR t IN (SELECT table_name FROM all_tables WHERE owner = 'PROD_ORDERMGMT' and (table_name like 'BTC%' or table_name like 'OM_%')) LOOP

        v_table_name := t.table_name;

        EXECUTE IMMEDIATE 'SELECT COUNT(1) FROM ' || v_table_name INTO v_row_count;

        DBMS_OUTPUT.PUT_LINE(v_table_name ||'#'|| v_row_count);

    END LOOP;

END;

/

No comments:

Post a Comment