Category: SQL
-
Table Data Comparison: Row Differences
A common task that database developers encounter is comparing data between two different sources to see rows with differences. This can be a table that is loaded with new data that needs to…
-
Cursor Basics: Cursor Iteration Controls
In the previous post we discussed the use of bulk collect and limit to optimize cursor iteration. This gave us a way to see the undocumented bulk prefetch optimization that has been applied…