Data comparison between two environments -Oracle

Question

To check new code functionality (Regression testing) , data copy needed of around 200 tables : Transactional based on date range , Config tables and ref tables.

Is there an efficient way of comparing the data between two environments ?This is a simple comparison of counts but very time consuming if done manually. Select Date , count() from Table_A where Date = test_date And Select count() from Ref_table

Answer 1

You can create DB link and use it in PL/SQL block to check the count by putting table name as hardcoded.