for cur in (select * from someTable) loop dbms_output.put_line(rec.field1 || '-'|| rec.field2 ||....); end loop;