-
regarding fetch across commits
is the following valide? is it good?
if it is not, what's other choice?
declare
cursor tab_row is select name,num_years_worked from names;
my_row tab_row%rowtype;
begin
for my_row in tab_row loop
if my_row.num_years_worked>5 then
update names set eligible_for_award='Y' where current of tab_row;
commit;
end if;
end loop;
end;
guru is on the way!!!!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|