Skip to Content
0
Former Member
Apr 21, 2009 at 09:07 PM

Report to be designed using multiple data bases

20 Views

Hi i got identical tables in oracle and sql server. my sample sql statement is like

select * from scott.emp

union all

select * from emp (this is sql server script)

i was unable to do this. the reason i think might be 1st sql is in oracle and 2nd sql is in sql server.

did any one encounter the problem if so please help us.

my question is how can we make a union all between 2 scripts 1 written in oracle and other in sqlserver

please help me soon