jueves, 24 de marzo de 2011

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