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