Comparing two tables

Hello everyone,

I’m recreating some old PL-SQL Oracle Package in Easymorph and atm I load the results in a new database because I need to compare the old tables with the new ones to be sure that everything is ok.

How I can do this in EM?

Hello Andrea,

You can try to make the project from this topic to compare two database tables instead of two Excel files:

But please keep in mind that the "Import from database" action may round or truncate the fractional part of float values. Also, it always truncates fractional seconds in timestamp\datetime values to 3 digits. So the comparison may yield a false-positive result for such cases.

Hello Andrew,

thanks for the reply: with some simple trick it works well even on database, really a useful .morph Project