title: search line break in several tables and get the rowid
body: <p>I have a list of tables and columns stored into &quot;CAMPOS_BL_FS_050321_2&quot; and i want to loop through that tables, only can i get one rowid for table, i need create an array to stored all rowid from a table, but i can't get the right code to works</p>
  <pre><code>DECLARE
    match_count varchar2(30 byte);
  BEGIN
    FOR t IN (SELECT SCHEMA_NAME,COLUMN_NAME,TABLE_NAME,DBLINK FROM CAMPOS_BL_FS_050321_2) LOOP
      EXECUTE IMMEDIATE
     'select rowid FROM ' || t.SCHEMA_NAME || '.' || t.TABLE_NAME || t.DBLINK ||' WHERE instr(' || t.COLUMN_NAME  || ', chr(10)) &gt; 0 and rownum=1'
     INTO match_count;
      IF match_count IS NOT null THEN
          insert into log_tabla values(t.COLUMN_NAME ,t.TABLE_NAME, match_count);
        COMMIT;
      END IF;
    END LOOP;
  END;
  /
  </code></pre>