I have used this blog to make announcements regarding the PL/SQL Challenge since April 2010.
We had a great run, and now we can look forward to a greater future, as the PL/SQL Challenge is now an Oracle website:
And that's not all: we now have an official blog at the official Oracle blogsphere:
So all future announcements will happen there.
As some of my readers may have noticed, I spend a lot of time these days among trees, paying attention to trees, cutting back invasive trees to save native trees, etc.
The heart of row pattern matching is finding which row matches what part of the pattern. Within the 12c
DEFINE lists the conditions a row may meet; it doesn't always work the way you expect, especially if you use aggregates in the condition.
Virtual Columns are really cool. I like them a lot. If you've never heard of them, shame on you, learn about them.
In short: a Virtual Column is not a real column, it's an expression that looks like a column... more or less.
While using the Virtual Columns, we ran into a little oddity with them.
I forgot to add a MATCH_RECOGNIZE solution to my last post on merging overlapping date ranges! That should take me just a few minutes, right? Wrong: it’s not that easy and here’s why. For test data, please refer to the previous post. To Merge or not to Merge? The idea is to merge date ranges if […]
It’s possible folks didn’t notice but Mac OS X no longer includes XQuartz by default from Maverick forward. You need to download XQuartz and install it. I’d recommend after you install Xcode.
Launch XQuartz and then either use the
bash shell it opens or open a Terminal
bash shell session. Inside the shell, you might start Secure Shell (
ssh) like this: