UNIX and Linux Applications

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;

cursor c1 IS
  select 
    employee_id 
  from 
    employee;
    
cursor c2 (p_employee_id) IS
  select 
    department_id 
  from 
    department 
  where 
    employee_id = p_employee_id;

BEGIN
  FOR c1_rec IN c1
  LOOP
    FOR c2_rec IN c2 (c1_rec.employee_id)
    LOOP
    ...

cursor c1 IS
  select 
    d.department_id 
  from 
    employee e,
    department d    
  where 
    d.employee_id = e.employee_id;

rec c1%rowtype;