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