Results of Oracle Dev Gym SQL Annual Championship for 2016
This post was originally published on this siteMarch 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…
DATABASE PATCH SET UPDATE 12.1.0.2.170117 apply fails – catconInit failed, exiting
This post was originally published on this siteLast weekend was patchday. The goal was to apply the patch 24732082 (DATABASE PATCH SET UPDATE 12.1.0.2.170117) to a 12.1.0.2 database on AIX. The OPatch precheck returned no error and OPatch apply was ok. The problem was the…
String to DATE conversion and validation in 12.2
This post was originally published on this siteA new little feature in Oracle Database 12.2 is, that you can convert strings to dates without worrying about exception handling. (That goes also for converting to numbers or timestamps or other datatypes, but here I’ll concentrate on…
Oracle Data Pump with the 12.2.0.1.0 Instant Client for Linux x86-64
This post was originally published on this siteFrom the Oracle Database 12c Release 2 (12.2) New Features Guide: Adding Oracle Data Pump and SQL*Loader Utilities to Instant Client This feature adds SQL*Loader, expdp, impdp, exp, and imp to the tools for instant client. Now you…
Oracle 12.2 – how to get access to Enterprise Manager 12c Database Express
This post was originally published on this siteToday I have built in my OL 7.3 VM two container databases to verify the new feature in the Enterprise Manager 12c Database Express login screen where I can go direct into a container. The benefit is that…
Temporal validity and open/closed intervals
This post was originally published on this siteA short while ago I created a SQL quiz for Oracle Dev Gym (PL/SQL Challenge) demonstrating the use of temporal validity and VERSIONS PERIOD FOR syntax to create a “change report” for changes in item prices. Use of…
Spring Data force version and lastmodified date to update on JPA Entity
This post was originally published on this siteSpring data has a feature that allows you to track automatically a certain amount of fields through annotations : @CreatedDate : The date on which the entity was created @CreatedBy : The user that created the entity @LastModifiedDate…
Announcing the SQL Annual Championship for 2016
This post was originally published on this siteI’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 to work my few braincells hard when it is time for…
Use Github as a CDN to store and serve static content (JavaScript, CSS, Images) with rawgit
This post was originally published on this siteIn this article I will be explaining how to use Github’s “raw” feature coupled with rawgit to store and serve static content Please note I assume you have some basic git knowledge 1.- Creating a Github account Ok…