Loop over records

From WickyWiki
Revision as of 07:26, 5 July 2013 by Admin (talk | contribs) (3 revisions)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
create table table1(id number, omschr varchar(100));
insert into table1(id,omschr) values(1,'test 1');
insert into table1(id,omschr) values(2,'test 2');
insert into table1(id,omschr) values(3,'test 3');
insert into table1(id,omschr) values(4,'test 4');
Commit;

set serveroutput on
declare
  cursor c1 is select * from table1 FOR UPDATE;
  cnt number default 0;
begin 
  for x in c1 loop
    update table1 set omschr=omschr||'.' where current of c1;
    cnt := cnt + sql%rowcount;
    dbms_output.put_line( 'processing ' || cnt || ' records...' );
  end loop;
end;
/
commit;
select * from table1;