Blog: Kim Berg Hansen

213 blogs updated: 30 min. ago
ODC Appreciation Day : The ever growing toolbox
It's ODC Appreciation Day ! The day initiated by Tim Hall where Oracle bloggers worldwide make a blog post to show appreciation of the Oracl...
11-10-2018 22:24:30 Kim Berg Hansen Oracle
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 ha...
01-05-2018 17:25:24 Kim Berg Hansen Oracle
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 Republi...
22-03-2018 17:06:18 Kim Berg Hansen Oracle
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...
13-02-2018 23:09:56 Kim Berg Hansen Oracle
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 throu...
12-01-2018 09:26:06 Kim Berg Hansen Oracle
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 s...
21-12-2017 10:14:18 Kim Berg Hansen Oracle
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 ...
10-10-2017 06:57:28 Kim Berg Hansen Oracle
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...
28-09-2017 15:46:32 Kim Berg Hansen Oracle
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 d...
19-08-2017 12:23:26 Kim Berg Hansen Oracle
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...
29-05-2017 16:26:33 Kim Berg Hansen Oracle

© Jiri Pinkas | this project on GitHub | related: SQL školení | Top Java Blogs | monitored using: sitemonitoring

Top SQL Blogs is a blog aggregator (with English-written blogs only) focused on MySQL, PostgreSQL, MS-SQL and Oracle databases.