17,086
社区成员
发帖
与我相关
我的任务
分享
create or replace procedure test1
is
num1 number(10);
num2 number(10);
num3 number(10);
--...
begin
select sum(a) into num1 from table1 where 1=1;
select sum(a) into num2 from table2 where 1=1;
select sum(a) into num3 from table3 where 1=1;
--...
insert into table(a1,a2,.....a6) values(num1,num2,.....num6);
commit;
end;