(1)如果逐一对某个表的记录更新,那么可以根据rowid去查找需要更新的记录;
FOR l_rowid IN (SELECT rowid FROM t_table1)
LOOP
update t_table1
set column1='**'
where rowid = l_rowid;
end loop;
FOR l_rowid IN (SELECT rowid FROM t_table1)
LOOP
update t_table1
set column1='**'
where rowid = l_rowid;
end loop;