Could someone explain to me using the WHERE CURRENT OF???
Thank you!!!
declare
cursor cur1 is select i, c from test_for_cursor for update;
begin
for aa in cur1 loop
if aa.i>12 then
update test_for_cursor set i=i*2, c=upper(c) where current of cur1;
end if;
end loop;
end;
WHERE rowid= vur1.rowid
Users browsing this forum: No registered users and 3 guests