set serveroutput on
declare
c integer;
cursor cur_rec is
select 'Select count(*) from ' || owner || '.' || table_name AS C_QUERY, OWNER, TABLE_NAME
FROM ALL_TAB_COLUMNS
WHERE  owner IN ('SCOTT', 'SYSTEM') ;
 
 
begin
    FOR rec in cur_rec
    	LOOP
    		begin
			EXECUTE IMMEDIATE rec.c_query into c;
			dbms_output.put_line('Schema.TableName: ' || rec.OWNER || '.' || rec.TABLE_NAME ||  ' count:' || c);
		end;
	END LOOP;
end;
/