with function row_count(tab_name in varchar2) return number as
    rc number;
begin
    execute immediate 'select count(*) from ' || tab_name into rc;
    return rc;
end;
select table_name, row_count(table_name) as row_count from all_tables
    where owner = 'owner';
/