Over the past few years, I’ve stopped using the Update statement, and started using the Merge statement for updates instead. While many use it to do both inserts and updates at the same time, you can use Merge for only updates, or inserts.
Say I want to update some fields in the SCOTT schema. Traditionally, I would first do the analysis by looking at the data.
Read the rest of this entry »