msql事务

create table B as select * from A where 1=0;
declare
    cursor ind is select * from A ;
    begin
        for cur in ind
        loop
            for num 1..2
            loop
                insert into B values ( cur.id||num, cur.name||num, note );
            end loop;
        end loop;
    end ;

转载于:https://my.oschina.net/u/3652185/blog/1825055