Announcing participants in the Oracle Dev Gym SQL Championship 2019

2019 is over. Throughout the year over 1800 Oracle Database developers participated in the "Select from SQL" Tournament on Oracle Dev Gym.

It's time for the Top 50 of those that played in the 2019 tournament to try their skills in the Annual SQL Championship, which will be held late February!

OGB Appreciation Day : How I failed to appreciate NULL

On the annual OGB Appreciation Day (#ThanksOGB has been renamed multiple times, see Tim Hall's blog post) I am going back in time to when I was a newbie developer, relating a story about me making a mistake that had bad consequences in the customer ERP system. Luckily I had experienced colleagues to repair the damage, and later in my career I learned about NULL and how it could have been so different back then.

Oracle Groundbreakers Tour Nordic 2019

In 4 weeks my first Oracle Groundbreakers Tour as ACE Director will begin. 4 Nordic capitals in 4 days, speaking about my favorite topic - SQL. SQL is as important as ever to work with data - even (or maybe especially) in this cloud era, where you can spin up, develop and deploy databases and apps without needing anything but a browser.

My Kscope19

A little later than many post-Kscope19 blog posts (because the wife and I just had a nice relaxing vacation week right after I returned from Kscope ;-), but better late than never. A few thoughts, but for once not a lot of writing - most of this post is a video...

Coming up: My 10th Kscope!

In June 2010 I attended ODTUG Kaleidoscope 2010 in Washington D.C. I got this T-shirt:

But I didn't get just a T-shirt, I got an awesome experience. And most importantly I got to be part of a fabulous community of friends all over the globe without whom I wouldn't be where I am today.

Being hooked from day one, I've been to each and every Kscope since - attending, speaking, ambassadoring, volunteering at all community service days, having fun, helping others, getting help, and so on. In short: getting my yearly inoculation against LowTech Syndrome.

It's also taken me around the US:

Kscope10	Washington D.C
Kscope11	Long Beach, California
Kscope12	San Antonio, Texas
Kscope13	New Orleans, Louisiana
Kscope14	Seattle, Washington
Kscope15	Hollywood, Florida
Kscope16	Chicago, Illinois
Kscope17	San Antonio, Texas
Kscope18	Orlando, Florida
Kscope19	Seattle, Washington

And now I am just *so* ready to go to Seattle for Kscope19 (my 10th anniversary Kscope), where I've got a packed schedule:

• Saturday: Bag stuffing - see if we can optimize the workload this year.
• Saturday: Community Service Day - this year packing lunches at Pike Market Food Bank.
• Sunday: Oracle Symposiums in the Database track.
• Sunday: Welcome Reception and Geek Game Night.
• Monday: Seeing scientific magic at the Keynote.
• Monday: Co-presenting on Helen Sanders' presentation "SQL on Steroids: BULK Processing."
• Monday: Interviewing the one and only Maria Colgan in the ODTUG Social Media Lounge.
• Monday: The OrclDB Community Night: "Database Everything But the Beanstalk."
• Tuesday: Moderating the Oracle Groundbreakers Lunch and Learn: Database Panel.
• Tuesday: Presenting my own session "Data Twisting."
• Tuesday: Eating and drinking with fellow members of the Oracle ACE Program.
• Wednesday: Being interviewed and taping a 2 Minute Tech Tip.
• Wednesday: Presenting my own session "Uses of Row Pattern Matching."
• Wednesday: The Big Party at the MoPOP.
• Thursday: The Deep Dive in the APEX track.

Add to that:

• Attending 8(ish) other presentations and learn something (still trying to decide which.)
• Mingle and chat at Breakfast, Lunch, Coffee/Tea Breaks, Happy Hours, etc.
• Visiting Exhibit Hall and see what's new.
• Meet as many old and new friends as possible.

When flying back home, I'll be bushed, but believe you me - it's worth it!

I'm not alone in thinking Kscope is a great conference. I do have a couple of colleagues from Trivadis also speaking:

Philipp Salvisberg will be speaking about:

• MLE—Java, JavaScript, Python, or PL/SQL in the Database?
• Testing with utPLSQL—Made Easy with SQL Developer

Dani Schnider will be speaking about:

• Avoid "Horror Queries": Keep Your SQL Simple and Fast
• How Autonomous Is the Oracle Autonomous Data Warehouse?

We're all looking forward to seeing you all in Seattle for ODTUG Kscope19.

Results of the Dev Gym SQL Championship for 2018

All the after-play checking of the results of Oracle SQL Annual Championship for 2018 is done. The awards have now been processed, and it is with great pleasure I can publish the results here to serve as an inspiration for you to trying out your own SQL knowledge at the Dev Gym.

ORA-22905 when calling ODCI Table functions from PL/SQL

Back in 2015 I experimented using ODCITable* functions to dynamically parse delimited text (see blog post here.)

Now blog reader Daniel Cabanillas points out, that it raises an error when used in PL/SQL. Silly me - I had only tried it out in SQL (my favorite language) and had completely missed that it failed in PL/SQL.

Lucky for me, the classic workaround of dynamic SQL works here too 😁