DECLARE
v_HIRE_DATE hr.EMPLOYEES.HIRE_DATE%TYPE;
CURSOR cur_employees IS
SELECt HIRE_DATE FROM hr.EMPLOYEES WHERe SALARY>3000;
BEGIN
OPEN cur_employees;
LOOP
FETCH cur_employees INTO new_employees;
EXIT WHEN new_employees%NOTFOUND;
DBMS_OUTPUT.PUT_LINE('HIRE_DATE:'||v_HIRE_DATE);
END LOOP;
COMMIT;
END;
请路过的大侠帮我看下错在哪里了？
DECLARE
v_HIRE_DATE hr.EMPLOYEES.HIRE_DATE%TYPE;
CURSOR cur_employees IS
SELECt HIRE_DATE FROM hr.EMPLOYEES WHERe SALARY>3000;
BEGIN
OPEN cur_employees;
LOOP
FETCH cur_employees INTO v_HIRE_DATE;
EXIT WHEN cur_employees%NOTFOUND;
DBMS_OUTPUT.PUT_LINE('HIRE_DATE:'||v_HIRE_DATE);
END LOOP;
COMMIT;
END;
如以上回答内容为低俗、色情、不良、暴力、侵权、涉及违法等信息，可以点下面链接进行举报！
点此我要举报以上问答信息