Tuesday, October 8, 2019

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.



Tuesday, September 24, 2019

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.

Monday, July 8, 2019

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...

Tuesday, June 18, 2019

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:

Kscope10Washington D.C
Kscope11Long Beach, California
Kscope12San Antonio, Texas
Kscope13New Orleans, Louisiana
Kscope14Seattle, Washington
Kscope15Hollywood, Florida
Kscope16Chicago, Illinois
Kscope17San Antonio, Texas
Kscope18Orlando, Florida
Kscope19Seattle, 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:


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:

Dani Schnider will be speaking about:


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

Monday, March 11, 2019

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.


Monday, January 14, 2019

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 😁

Participant list for Oracle Dev Gym SQL Championship 2018

2018 is over. Throughout the year people have participated in the "Select for SQL" Tournament on Oracle Dev Gym. It's time for the Top 50 to try their skills in the Annual SQL Championship!


Everybody who tried the quizzes have hopefully had fun as well as exercised SQL skills. Maybe even learned a little :-) I hope you'll all keep working your mental muscles in 2019 as well - get your friends and colleagues to try it too! I'll do my very best to try and pass on knowledge via the quizzes.

Whether you worked out with the quizzes for fun alone or you played in the tournament as well, thank you for being there in 2018. And congratulations to the Top 50 in the "Select for SQL" Tournament on Oracle Dev Gym in 2018 for the stamina and skill displayed to be ranked sufficiently high at the end of the year to participate in the Championship.