DECLARE
l_prev_empno emp.empno%TYPE;
l_prev_ename emp.ename%TYPE;
l_prev_job emp.job%TYPE;
BEGIN
IF TO_NUMBER (:SYSTEM.cursor_record) > 1
THEN
PREVIOUS_RECORD; /* move to the previous record and get previous record values */
l_prev_empno := :emp.empno;
l_prev_ename := :emp.ename;
l_prev_job := :emp.job;
NEXT_RECORD; /* come back to the current record */
END IF;
END;
No comments:
Post a Comment