declare
	v_emp emp.ename%type;
cursor c1 is select ename from emp where deptno=10;
begin
	loop 
		fetch c1 into v_emp;
		exit when c1%notfound;
		:emp.ename:=v_emp;
		next_record;
	end loop;
	
end;