create or replace procedure get_rowcnt
IS
v_cnt number;
cursor c1 is
select table_name from user_tables;

v_str varchar2(1000);
begin

for rc in c1 loop
v_str := 'SELECT count(*) from ' || rc.table_name || ' where model_val = ''S92'' ';
execute immediate v_str into v_cnt;
dbms_output.put_line('Number of rows in table ' || rc.table_name || ' = ' || v_cnt);
end loop;

end get_rowcnt;