I have a table that is being populated from a Materialized view.
I'm looking for a way to identify & update only records that have values that have changed. I have thought about using Oracle's standard hash function to check data consistency but, and please correct me if I'm wrong, but I think this would just tell me "something" changed, not "what changed".
Is there a "best" way to do this type of comparison?
You should take a look at the MERGE Statement. This should serve you well.