test2.sql

来自「Expert Oracle Database Architecture 9i a」· SQL 代码 · 共 11 行

begin
    for i in 1 .. 1000
    loop
        update small set y = i where x= &1;
        commit;
    end loop;
end;
/
exit