why not build 3 temp table locally?: Select * from 表名...@ where org_id=机构号1 into temp_table1; Select * from 表名...@ where org_id=机构号2 into temp_table2; Select * from 表名...@ where org_id=机构号3 into temp_table3; and then: Select * from temp_table1 union Select * from temp_table2 union Select * from temp_table3 and ,oracle has a module called "Replication",you can try it(i havn't touched it ,so seek the Oracle-help yourself please)
Select * from 表名...@
where org_id=机构号1 into temp_table1;
Select * from 表名...@
where org_id=机构号2 into temp_table2;
Select * from 表名...@
where org_id=机构号3 into temp_table3;
and then:
Select * from temp_table1
union Select * from temp_table2
union Select * from temp_table3 and ,oracle has a module called "Replication",you can try it(i havn't touched it ,so seek the Oracle-help yourself please)
再用对这些临时表的快照来处理你的程序呀。
程序只需要添加一个模块去处理采集数据就可以了,这应该不是很困难实现吧