Oracle :: Exemplo de Procedure com FOR

Create or Replace Procedure p (ename in varchar2) as

Begin

   for x in (select * from emp where name = ename) loop
      dmbs_output.put_line(x.empno);
   end loop;

End;

/