code 3

3.Write a code to demonstrate plsql implicit cursors?

sol:

Declare
e tab2.eno%type;
n tab2.ename%type;
d tab2.deptno%type;
Begin
d:=&d;
update tab2 set sal=7000 where deptno=d;
if sql%found then
dbms_output.put_line('records updated');
else
dbms_output.put_line('no records updated');
end if;
end;
/

---

Bollywood, fun, friendship, sports and more. You name it, we have it.