ex-2
-----------
-
-
create or replace procedure testproc(no emp.empno%type,rec out emp%rowtype)
-
is
-
cursor c is select * from emp where deptno=no;
-
begin
-
open c;
-
loop
-
fetch c into rec;
-
exit when c%notfound;
-
DBMS_OUTPUT.PUT_LINE(rec.empno||' '||rec.ename||' ' ||rec.job||' ' ||rec.sal);
-
end loop;
-
close c;
-
end ;
-
-----------------------------------
-
TO EXECUTE
-
-----------------------------------
-
declare
-
r emp%rowtype;
-
begin
-
testproc(10,r);
-
end;
-
-
now try few more yourself