Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How To Compare Table data In two different databases

User_UMJZ5Aug 30 2013 — edited Aug 30 2013

Hi,

I need sql querry to compare data in different databases.I have one table Emp in  one database and same emp table in another

database.I need to check whether both the tables having same data or not.Both Table structure are same.

I know sql for this check two different tables in same database.I need sql for different databases comparison.

i.e, select emp_id from emp1  minus select emp_id  from emp2 ---This sql used both the tables are present in same Database.

Please any one can help on this...
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 27 2013
Added on Aug 30 2013
3 comments
592 views