December 14th

I received an email this morning with a link to a Linked-In post that pointed to someone's BLOG. The Blogger was proposing a solution to a problem someone had presented to him at work that he thought was rather elegant and so posted it for the consumption and edification of the Linked-In community. The problem: In a single SQL statement register an attendee for an event unless the attendee is already registered for an overlapping event. The solution was, to me, overly complex and absolutely non-portable in that it takes advantage of Oracle's conditional INSERT statement, so I said to mysel

December 3rd

November 30th

Often time there is there is a requirement to track when users log-in to a database, how long they were accessing the database and what resources were consumed. This information can be used for auditing or charging for use of a database by the resources consumed by the user.

Accomplishing this is simple and utilizes the sysdbopen/sysdbclose procedures along with the sysmaster database.