code no 4 & 5

4.Write a plsql code to display the name of all employes working in a particular dept?

sol:

Declare
cursor c1 is select ename from tab2 where deptno=&d;
n tab2.ename%type;
Begin
open c1;
loop
fetch c1 into n;
exit
when c1%notfound;
dbms_output.put_line(n);
end loop;
close c1;
end;
/

5.Write a plsql code to disp names using explicit cursor?

sol:

Declare
cursor c1 is select ename from tab2;
n tab2.ename%type;
Begin
open c1;
loop
fetch c1 into n;
exit
when c1%notfound;
dbms_output.put_line(n);
end loop;
close c1;
end;
/

---

Find a mall, hotel or ATM in any part of India. Click here.