begin
insert into tbname values('aaa','bbb');
insert into tbname1 values('aaa','bbb');
...
insert into tbnamen select * from tbnamem where ...;
end;
/
insert into tbname values('aaa','bbb');
insert into tbname1 values('aaa','bbb');
...
insert into tbnamen select * from tbnamem where ...;
end;
/
insert into test values(字段1,...字段n);
commit;向多个表中插入一条记录:
insert into test1 values(字段1,...字段n);
insert into test2 values(字段1,...字段n);
insert into test3 values(字段1,...字段n);
commit;可以建一个存贮过程来做,最好自已动手做,
通过和计算机反复交流能发现自已的不足,加深印象。
創建