将news表中的htmlpath修改成为'news/news.jsp?nid=' + 本行id
declare
rn varchar2(40) :='news/news/jsp?nid=';
n number := 0;
begin
for cl in (select id from news order by id) loop
n :=n+1;
update news
set htmlpath=rn|| id
where id=cl.id;
commit;
end loop;
end;