Blog: Kim Berg Hansen

209 blogs updated: 43 min. ago
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
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....
05-04-2017 18:58:49 Kim Berg Hansen Oracle
String to DATE conversion and validation in 12.2
A new little feature in Oracle Database 12.2 is, that you can convert strings to dates without worrying about exception handling. (That goes...
05-04-2017 09:43:06 Kim Berg Hansen Oracle
Temporal validity and open/closed intervals
A short while ago I created a SQL quiz for Oracle Dev Gym (PL/SQL Challenge) demonstrating the use of temporal validity and VERSIONS PERIOD ...
23-01-2017 09:56:20 Kim Berg Hansen Oracle
Announcing the SQL Annual Championship for 2016
I've been making SQL quizzes for years now over at the Oracle Dev Gym (or PL/SQL Challenge as it started out as.) Every year I really have t...
19-01-2017 17:15:37 Kim Berg Hansen Oracle
A handful of articles
A little while ago a member of the Danish Oracle User Group DOUG asked if anyone had a bit of experience with use of R together with Oracle ...
05-11-2016 12:31:07 Kim Berg Hansen Oracle
OTN Appreciation Day : GeoJSON and SDO_GEOMETRY marriage in Oracle 12.2
The native JSON functionality in Oracle Database version 12.2 has evolved quite a bit since the JSON functions first appeared in Oracle Data...
11-10-2016 09:00:38 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.