Category Archives: Databases

In Oracle, the standard way to calculate the difference (delta) between two values is using the LAG() analytic function. For example… Suppose you’ve got a table of numeric values– create table t as select rownum id, value from v$sesstat where … Continue reading →

I’ve got a script that runs through the alert logs for all the Oracle databases I manage every 10 minutes or so and sends me a text message containing the error number if it finds an error. Sometimes, when the … Continue reading →

After two months in the wilderness, my tutorial on the Three Normal Forms is back online. I took it down because in the original, it had some serious flaws. While not factually inaccurate, the section pertaining to NF1 was vague … Continue reading →