Comparing multiple columns in a table: Regression Testing

Good Evening,

I am currently performing regression testing and would like to write a query which automatically compares the values in columns between two tables. Hoping to automate this feature in the future too.

We are currently using an Oracle and MYSQL based environment.

Help would be greatly appreciated.