Log Mining in Oracle 10g

If you ever had to perform log mining in Oracle prior to 10g, you will be pleasantly surprised by how easy and fast it is in 10g. After using 10g for several years, I finally got a chance to use log miner in 10g. Until now, flashback queries were always enough to recover errant deletes and updates.  Allow me to explain.

The Best XHR Script

XHR or XMLHttpRequest is arguably the cornerstone of the web 2.0 schlock and, honestly, I think it does add a great deal of value to a web application when you can execute requests and not lose your context. For example, given a list of 500+ comments to review and edit, it’s nice to be able to edit them in place rather than, edit, submit, and scroll to find where you left off. That said, I […]

Three Simple Date Functions

Over the years, I found that I was always typing the same lines of code to get at a very simple piece of information. At first, writing date functions seemed like a dumb idea. I mean, why would you need a function that returns the first day of a given month? The first of the month is always the first. I mean, the last_day(date) function makes sense. Some months have 30 days, some have 31, […]