Easy Learning... (Web Development,.NET Technology,Oracle,Silverlight,REST,SQL,Oracle,MySQL,Data Science, Python and many more ...)
set serveroutput on
declare
cursor cremp is
select Eno, ESalary from Emp;
begin
for rec1 in cremp
loop
update Emp set ESalary = rec1.ESalary + rec1.ESalary * 0.2
where Eno = rec1.Eno;
end loop;
end;
/
commit;
Thanks for showing your interestI will shortly get back to you
No comments:
Post a Comment
Thanks for showing your interest
I will shortly get back to you