Results of the Dev Gym SQL Championship for 2019
Another Oracle Dev Gym championship in the domain of SQL is completed! 33 participants did an awesome job on the extra-tough quizzes I concocted. Congratulations first and foremost to the top-ranked players: 1st Place: Stelios Vlasopoulos 2nd Place: mentzel.iudith 3rd Place: Aleksei Davletiarov Next, congratulations…
The “Practical Oracle SQL” book is available…
You all know I’ve been writing on this book called “Practical Oracle SQL”, right? Well, now it’s available for purchase: https://www.apress.com/gp/book/9781484256169 Or you can find it on Amazon too: https://www.amazon.com/Practical-Oracle-SQL-Mastering-Database/dp/1484256166 If you want to know more about why I wrote it and what’s in it,…
A couple articles…
In case you missed a couple tweets last week, I’d like to point you to a couple articles by me that was recently published. In the Oraworld Magazine was published: My travel journal about the Oracle Groundbreakers Nordic Tour 2019 in October. In the NoCOUG (Northern…
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,…
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…
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,…
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…
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…
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…
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…