Posted by: Beth Pariseau
Oracle database administration, Oracle development
On this fine spring Friday I thought I’d point to a few things going on around the Oracle blogosphere.
First, an update on OTN’s blogging cred. Justin Kestelyn posts an update saying he’s glad he complained, as he’s gotten a lot of good feedback and advice from other bloggers. Vincent McBurney posted a very thorough analysis on his blog comparing OTN traffic stats to those of the ITToolbox blogs and some other networks. More thoughts from Doug Burns and Brian Duff, who writes that he agrees with Robert Scoble’s ideas for building a stronger blogging community.
As a poet and dabbler in other modes of creative writing outside of my Oracle-related life, I was delighted to see a post called “Working under constraints” on Andrew Clarke’s blog. He had answered a question on a PL/SQL forum in which the user asked how to do something without triggers, when triggers were clearly the easiest option. Why the constraint, he wondered? Was it simply an arbitrary way to “drive creativity”? He compared this to the Oulipo school of writing, the most famous example of which is the lipogram A Void, which is written entirely without the use of the letter “e.” Our forums also receive questions like this, such as “LEFT OUTER JOIN without using LEFT OUTER JOIN.” Our SQL expert Rudy Limeback responded, but added “I have difficulty imagining the circumstances which would lead to this requirement.”
And finally, some tip series you might find useful: For you JOINs lovers out there, Eddie Awad offers an Oracle joins series, the most recent installment of which covers anti-joins and semi-joins. And Chris Foot provides his “10 things I like about 10g” series (parts 1, 2 and 3), which reviews some of the nice features in Oracle 10g that might otherwise be overlooked.
Have a good weekend,