Profile cover photo
Profile photo
Kim Berg Hansen
90 followers -
Oracle SQL Evangelist
Oracle SQL Evangelist

90 followers
About
Posts

Post has attachment
Corrupting characters - How to get invalid byte values stored in strings
Having worked with Database Migration Assistant for Unicode (DMU) to convert some databases from single-byte charactersets to AL32UTF8, I had problems with DMU reporting a lot of characters with invalid byte values (in this case binary values that did not e...
Add a comment...

Post has attachment
Announcing the results of the Oracle Dev Gym SQL Championship for 2017
A huge round of applause to the top players in the championship: 1st Place: mentzel.iudith of Israel 2nd Place: Pavel Zeman of Czech Republic 3rd Place: Andrey Zaytsev of Russia Especially noteworthy is the accomplishment of Iudith Mentzel, who also won the...
Add a comment...

Post has attachment
SQL Magic Squares - or Why the Optimizer does not like Magic
A long-time player at the Oracle Dev Gym tried his hand at generating Magic Squares using SQL. When he attempted to tune his statement a bit, he was surprised that it didn't go a little faster as expected, rather it went from 2 minutes to 45 minutes? At tha...
Add a comment...

Post has attachment
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...
Add a comment...

Post has attachment
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...
Add a comment...

Post has attachment
ODC Appreciation Day: Cursor Variables
You know everything is Tim Hall s 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 blogg...
Add a comment...

Post has attachment
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 while ago to co...
Add a comment...

Post has attachment
**
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 while ago to co...
Add a comment...

Post has attachment
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 ...
Add a comment...

Post has attachment
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 u...
Add a comment...
Wait while more posts are being loaded