SELECT table_name, 
       num_rows 
  FROM dba_tables 
  where owner = 'semaniz'

declare
    v_count integer;
begin

    for r in (select table_name, owner from all_tables         where owner = 'sizinsema') 
    loop
        execute immediate 'select count(1) from ' || r.owner ||'.'|| r.table_name into v_count;
        INSERT INTO KayitEdeceginizTablo(TABLE_NAME,SCHEMA_NAME,RECORD_COUNT,CREATED)
        VALUES (r.table_name,r.owner,v_count,SYSDATE);
    end loop;
    
    COMMIT;

end;