DECLARE
vEmployee_id employees.employee_id%TYPE;
CURSOR parImparCursor IS
SELECT EMPLOYEE_ID
from employees for UPDATE;
BEGIN
OPEN parImparCursor;
LOOP FETCH parImparCursor INTO vEmployee_id;
EXIT when parImparCursor%NOTFOUND;
dbms_output.put_line(vEmployee_id);
END LOOP;
CLOSE parImparCursor;
END;
No hay comentarios.:
Publicar un comentario