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;
请路过的大侠帮我看下错在哪里了?