try:组合成类似的语句形式
begin
insert into tbname values ...;
insert into tbname values ...;
insert into tbname values ...;
end;
begin
insert into tbname values ...;
insert into tbname values ...;
insert into tbname values ...;
end;
这样可以吗
用DOA控件好了,专为Oracle定做的,其中的TOracleDataSet等都可以执行PL/SQL块。
var
dataset1:toracledateset;
begin
dataset1:=toracledateset1.create(self);
try
with dataset1 do
begin
session:=mainsession; //mainsession是Toraclesession
sql.add('begin');
sql.add('insert into ...;');
sql.add('insert into ...;');
....
sql.add('end;');
executesql;
end;
mainsession.commit; finally
dataset1.free;
end;
end;
组合成类似的语句形式
insert into tbname
select 'aaa','bbb','ccc' from dual
union all
select 'aaa','bbb','ccc' from dual
union all
select 'aaa','bbb','ccc' from dual;