Announcing participants in Oracle Dev Gym SQL Championship 2017
Another year, another Oracle Dev Gym SQL Annual Championship. Woohoo! Players have exercised their mental muscles with the SQL puzzles throughout 2017. Congratulations to everybody digging in all year, trying to figure out the pretzelbenders of me and other quiz authors. And hopefully you’ve learned…
Roleplaying Dimensions and SSAS Multidimensional
Yes, I can hear you, SSAS Multidimensional is so old and unsexy. Still, a lot of the data warehouse projects I work on still use this techonology. So what is a roleplaying dimension? It’s quite simply a dimension, that plays different roles in regard to…
Object type „nested“ implicit grants
A colleague got an „ORA-01720: grant option does not exist“ error and couldn’t understand why. So together we researched a bit and learned some things about how object type grants across schemas works – including a small surprise that was the reason for our puzzlement….
Hunting date errors
Just recently, I had to find out, why a dataload, that had been working smoothlessly in the past, suddenly prodced an error. The data is coming from an ORACLE database, and imported into MS SQL Server with an OPENQUERY statement. The error message read: “Error…
SQL Server Graph Database and Performance
When Microsoft announced, that their upcoming release would contain an implementation of Graph Database objects, I was intrigued. There are already a couple of good posts around, that explain how to use the feature, e.g. how to create a table structure and query the information,…
ODC Appreciation Day: Cursor Variables
You know everything is Tim Halls fault, right? Including this blog post? Oh yes it is, he came up with the idea of OTN ODC Appreciation Day – a day where Oracle Bloggers all over the world show their appreciation of the Oracle Developer Community by…
Avoiding reinventing the wheel – use MULTISET EXCEPT to get set relative complement
Today in an application I stumbled upon a PL/SQL function created to return those elements of one nested table that did not exist in another nested table. Not a huge function, but still a bit of work and some thinking that had been done some…
Partitioning external tables in 12.2
One of the new features in Oracle 12.2 is partitioning of external tables – a quite useful feature if you have multiple identical files of data, for example from multiple sources. But how can you partition external files, you ask? Well, you don’t partition the…
Collation in 12cR2 – when AA equals Å (or not?)
Collation in Oracle 12cR2 gives some more finegrained possibilities for setting up how your data is to sorted and compared linguistically. A lot we could do before with NLS_SORT and NLS_COMP and the likes, but the collation features can both be simpler to use as…
Results of Oracle Dev Gym SQL Annual Championship for 2016
March 29th 2017 a group of 35 database developers competed in the Oracle Dev Gym SQL Annual Championship for the top ranked players of 2016. They worked their little grey cells hard for 45 minutes over 5 quizzes that I had tried to make extra…
Social Media @trivadis