PL/SQL Cursor to Update Table Records

PL/SQL Cursor to Update Table Records:

declare
cursor cupd is select * from student for update;
begin
for i in cupd
loop
update student
set city=initcap(city),
salary=salary+100
where current of cupd;
end loop;
end;

You may also like...

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.