I have to create a view which pulls data from multiple remote databases . I have the logic for queries for each of the databases. I need to combine the( basically union) the results of the query to create a view
Pseudo code is below
query1 - remote Database1 (RDB1)
select a,b,c from x , y, z where < lot of conditions>...
Query2 : Remote database :RDB2
Select a,b , c from P, q,r,s,t where < various conditions>
Query3 Remotedata base 3: RDB3
Select a, b , c from D,E,F,G,H,I where < conditions>
I need a create a view in local database ( let us call it LDB) which basically unions three queries mentioned above and creates a view.
Assuming thee database links are created say dl1, dl2, dl3 how do I do this?
THanks in advance