Oracle: Row count of all tables which has ID column

row-count-all-user-tables-column-id.sql

SET SERVEROUTPUT ON
DECLARE ROW_COUNT NUMBER(10);
BEGIN
  -- All user tables with column ID.
  FOR TAB IN (SELECT TABLE_NAME FROM USER_TAB_COLUMNS WHERE COLUMN_NAME = 'ID' ORDER BY TABLE_NAME)
  LOOP
    EXECUTE IMMEDIATE 'SELECT COUNT(1) FROM ' || TAB.TABLE_NAME INTO ROW_COUNT;
    DBMS_OUTPUT.PUT_LINE( TAB.TABLE_NAME || ',' || ROW_COUNT );
  END LOOP;
END;
/

row_count_all_user_tables.sql

SET SERVEROUTPUT ON
DECLARE ROW_COUNT NUMBER(10);
BEGIN
  -- All user tables.
  FOR TAB IN (SELECT TABLE_NAME FROM USER_TABLES ORDER BY TABLE_NAME)
  LOOP
    EXECUTE IMMEDIATE 'SELECT COUNT(1) FROM ' || TAB.TABLE_NAME INTO ROW_COUNT;
    DBMS_OUTPUT.PUT_LINE( TAB.TABLE_NAME || ',' || ROW_COUNT );
  END LOOP;
END;
/