Is This Oracle Cursor Syntax Correct?
Posted on 2013-01-09
I need someone to review my attempt at an Oracle cursor. I am attempting to loop through a series of tables to find employee numbers that exist in a temp table:
SELECT employee_num from tmp_employeenums
fetch empcur into emp_record
exit when empcur%notfound;
SELECT * from vacationdays where cavempnum = emp_record;
SELECT * from sickdays where sicempnum = emp_record;