You are viewing this site as a guest. You can still ask questions and help others! Join our Dev2Dev IT Community to receive your own blog, share your knowledge, and much more.

compare data from two identical tables

2 replies [Last post]
Guest's picture
Guest

hi guys i am tryin to compare data from two identical tables E6900 and M9000 and this my DBlink ops$mis_exec.mis_sub_prof@prod
so my query is as follows i am not sure whether i am on the right track

select * from ops$mis_exec.mis_sub_prof@prod minus select * from ops$mis_exec.mis_sub_prof;

Lepa's picture
User offline. Last seen 48 weeks 2 days ago. Offline
Joined: 06/23/2008
Posts: 591
Re: compare data from two identical tables

Are you getting any errors? You also need to make sure that the password in both environments is the same.

Give back to the community and help it grow!
* Help with unanswered forum questions and issues
* Register or login to share your knowledge at your own blog

Ashar's picture
User offline. Last seen 3 years 29 weeks ago. Offline
Joined: 03/26/2008
Posts: 227
Re: compare data from two identical tables

You would like to look at these blog posts Compare Data in tables and Compare Data in Similar Tables