BEGIN for recordOne in (select id, name from cfftest.student) loop print recordOne.id || ' ' || recordOne.name; end loop; select 'ok'; END;