表depsInfo创建脚本以及测试数据脚本如下：
create table depsInfo (appid char(2), depsRow number(5), depsMoney number(9,2));
insert into depsInfo (APPID, DEPSROW, DEPSMONEY)values ('01', 3, 50.00);
insert into depsInfo (APPID, DEPSROW, DEPSMONEY)values ('01', 2, 20.00);
insert into depsInfo (APPID, DEPSROW, DEPSMONEY)values ('02', 20, 200.00);
insert into depsInfo (APPID, DEPSROW, DEPSMONEY)values ('02', 10, 100.00);
insert into depsInfo (APPID, DEPSROW, DEPSMONEY)values ('02', 10, 100.00);
insert into depsInfo (APPID, DEPSROW, DEPSMONEY)values ('03', 15, 100.21);
insert into depsInfo (APPID, DEPSROW, DEPSMONEY)values ('03', 11, 29.00);
insert into depsInfo (APPID, DEPSROW, DEPSMONEY)values ('03', 1, 14.00);
insert into depsInfo (APPID, DEPSROW, DEPSMONEY)values ('04', 4, 15.00);
insert into depsInfo (APPID, DEPSROW, DEPSMONEY)values ('04', 13, 142.00);
/*
数据如下：
appid depsRow depsMoney rowid
1 01 3 50.00 AAAOzcAAEAADXilAAA
2 01 2 20.00 AAAOzcAAEAADXilAAB
3 02 20 200.00 AAAOzcAAEAADXilAAC
4 02 10 100.00 AAAOzcAAEAADXilAAD
5 02 10 100.00 AAAOzcAAEAADXilAAE
6 03 15 100.21 AAAOzcAAEAADXilAAF
7 03 11 29.00 AAAOzcAAEAADXilAAG
8 03 1 14.00 AAAOzcAAEAADXilAAH
9 04 4 15.00 AAAOzcAAEAADXilAAI
10 04 13 142.00 AAAOzcAAEAADXilAAJ
*/
表bsaInfo创建脚本以及测试数据脚本如下：
create table bsaInfo (appid char(2), bsaRow number(5), bsaMoney number(9,2));
insert into bsaInfo (APPID, BSAROW, BSAMONEY)values ('02', 2, 30.00);
insert into bsaInfo (APPID, BSAROW, BSAMONEY)values ('02', 3, 70.00);
insert into bsaInfo (APPID, BSAROW, BSAMONEY)values ('03', 5, 100.00);
insert into bsaInfo (APPID, BSAROW, BSAMONEY)values ('03', 2, 35.00);
insert into bsaInfo (APPID, BSAROW, BSAMONEY)values ('03', 6, 261.00);
insert into bsaInfo (APPID, BSAROW, BSAMONEY)values ('03', 32, 147.00);
insert into bsaInfo (APPID, BSAROW, BSAMONEY)values ('03', 123, 1231.00);
insert into bsaInfo (APPID, BSAROW, BSAMONEY)values ('03', 234, 2134.00);
insert into bsaInfo (APPID, BSAROW, BSAMONEY)values ('04', 3, 23.00);
insert into bsaInfo (APPID, BSAROW, BSAMONEY)values ('04', 5, 52.00);
insert into bsaInfo (APPID, BSAROW, BSAMONEY)values ('04', 6, 43.00);
insert into bsaInfo (APPID, BSAROW, BSAMONEY)values ('04', 12, 158.00);
/*
数据如下：
appid bsaRow bsaMoney rowid
1 02 2 30.00 AAAOzdAAEAADXkFAAA
2 02 3 70.00 AAAOzdAAEAADXkFAAB
3 03 5 100.00 AAAOzdAAEAADXkFAAC
4 03 2 35.00 AAAOzdAAEAADXkFAAD
5 03 6 261.00 AAAOzdAAEAADXkFAAE
6 03 32 147.00 AAAOzdAAEAADXkFAAF
7 03 123 1231.00 AAAOzdAAEAADXkFAAG
8 03 234 2134.00 AAAOzdAAEAADXkFAAH
9 04 3 23.00 AAAOzdAAEAADXkFAAI
10 04 5 52.00 AAAOzdAAEAADXkFAAJ
11 04 6 43.00 AAAOzdAAEAADXkFAAK
12 04 12 158.00 AAAOzdAAEAADXkFAAL
*/
要求实现后达到效果表（模拟手动创建）以及数据（手动加的）脚本
create table gatherInfo (appid char(2), depsRow number(5), depsMoney number(9,2),bsaRow number(5), bsaMoney number(9,2));
insert into gatherInfo (APPID, DEPSROW, DEPSMONEY, BSAROW, BSAMONEY)values ('01', 3, 50.00, 0, 0.00);
insert into gatherInfo (APPID, DEPSROW, DEPSMONEY, BSAROW, BSAMONEY)values ('01', 2, 20.00, 0, 0.00);
insert into gatherInfo (APPID, DEPSROW, DEPSMONEY, BSAROW, BSAMONEY)values ('02', 20, 200.00, 2, 30.00);
insert into gatherInfo (APPID, DEPSROW, DEPSMONEY, BSAROW, BSAMONEY)values ('02', 10, 100.00, 3, 70.00);
insert into gatherInfo (APPID, DEPSROW, DEPSMONEY, BSAROW, BSAMONEY)values ('02', 10, 100.00, 0, 0.00);
insert into gatherInfo (APPID, DEPSROW, DEPSMONEY, BSAROW, BSAMONEY)values ('03', 15, 100.21, 5, 100.00);
insert into gatherInfo (APPID, DEPSROW, DEPSMONEY, BSAROW, BSAMONEY)values ('03', 11, 29.00, 2, 35.00);
insert into gatherInfo (APPID, DEPSROW, DEPSMONEY, BSAROW, BSAMONEY)values ('03', 1, 14.00, 6, 261.00);
insert into gatherInfo (APPID, DEPSROW, DEPSMONEY, BSAROW, BSAMONEY)values ('03', 0, 0.00, 32, 147.00);