This content has been marked as final. Show 2 replies
create view V_XYZ as select * from A.XYZ union select * from B.XYZ;1 person found this helpful
select * from V_XYZ where date range between 15-Oct-2011 to 15-Mar-2012
Thanks for the reply
Creating an view is an option.
But my problem, there is ORM layer(either Hibernate or Eclipse Top Link) between the application and the database.
So the queries would be formed by the ORM layer and are not hand generated.
So i cannot use view.
So is there any option that would allow me to use single query on different schema's ?