Oracle SQL cursor

declare cursor layersIDs is select TO_NUMBER(lay_id) as lay_id from layers order by lay_id; rec layersIDs%rowtype; begin for rec in layersIDs loop dbms_output.PUT_LINE (rec.lay_id); end loop; end;