i have 2 cursors. i want to assign the value of first cursor(employee_id) to the where condition of cursor c2(please refer the bold statement).
how do i do if i want to assign the value of c1 to where condition of cursor c2?
declare
cursor c1 IS
select employee_id from employee
cursor c2 IS
select department_id from department where employee_id=C1.employee_id
begin
for eid in c1 loop
if eid!=' ' then
for dept_id in c2 loop
<some operations>
end loop;
end if;
end loop;
end;