Author Archives

Pushing the Technical Frontier

I have a dilemma. In the BI system that I’m working on I have the perfect application for the use of Expression Filters. It is almost as if someone specifically devised this problem in order to tempt me into using them, and I really am very tempt…

Listing DBMS_Scheduler Named-Calendar Dates with SQL

Just a quick follow up to my post from the other day about using DBMS_Scheduler to generate lists of dates in SQL. I mentioned that you can use named schedules in this method, and that’s actually a handy way of testing your schedule definition. T…

Generating Lists of Dates in Oracle the DBMS_Scheduler Way

A rather common question in the Oracle community goes along the lines of this: “How do I generate a list of dates?”, with variations such as needing only working days, excluding specific dates, etc.. If there is a standard method for this i…

Has Everyone Forgotten “Keep It Simple, Stupid”?

OK, we all love a clever piece of code to do something a little bit tricky, but has everyone lost sight of the benefits of simplicity? My case study for the day, a thread on the Oracle forums in which various all_objects, user_objects, connect by, MODE…