一段简单的Oracle游标的代码

DECLARE

new_employees hr.EMPLOYEES%ROWTYPE;

CURSOR cur_employees IS

SELECt * FROM hr.EMPLOYEES

FOR UPDATe OF DEPARTMENT_ID;

BEGIN

OPEN cur_employees;

LOOP

FETCH cur_employees INTO new_employees;

EXIT WHEN cur_toy%NOTFOUND;

DELETE FROM hr.EMPLOYEES WHERe DEPARTMENT_ID=30

WHERe CURRENT OF cur_employees;

END LOOP;

COMMIT;

END;

请路过的大侠帮我看下错在哪里了？

EXIT WHEN cur_toy%NOTFOUND;

改成

EXIT WHEN cur_employees %NOTFOUND;

如以上回答内容为低俗、色情、不良、暴力、侵权、涉及违法等信息，可以点下面链接进行举报！

点此我要举报以上问答信息