I have a huge table which has 300 columns and around 4 billion records some of the data in column got messed up. I just want to c which column has been change and how many records got messed up. how do we do that. is there any way to find out using sql or plsql.
i have old data for the year and new data for the year how do we compare and find the changes in column
for example
| id | id number | id password | year |
|---|
| 1 | 1234 | asdf | 2018 |
| 2 | 1234 | dsaf | 2017 |
| 3 | 1234 | asdf | 2016 |
so i want to compare 2018 and 2017 and see what are the changes occured rest years can be ignore and i want to check for that 300 columns for 4 billion records. is that even posible?