Hi All,
I have to compare two databases(table to table). Data comparision. Please suggest best option.
i tried third party tools like DB solo, data examiner - It needs manual work(when table does not have any key).
i tried dbms comparision tool - i am not much aware of it. and it requires sysdba access. so it didnt worked out for me.
Finally, i decided to write a procedure.
My plan,
1. i take all columns using listagg function and use to get all records from both tables. and convert all the data to comma seperated lists.
2. by use of sys ref cursor, i do comma_to_table. then both data matches column by column No discrepancy else column doesnt match i'll display it.
Result:
i need to display discrepancy columns
Issues: the above approach wont work when data contains special characters, huge varchars, null handling,..
Please suggest better approach.. Thanks in advance.