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…
Oracle 12.2 – New Features I like – Part 1: Multitenant “Hot Clones”
This post was originally published on this siteI like the Oracle Multitenant architecture which was introduced in 12.1. But the concept to clone a source database to multiple copies in a small step had one big problem. In Oracle 12.1, to clone a pluggable database…
A handful of articles
This post was originally published on this siteA 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 Database. I remembered an article I wrote for OTech Magazine on…
Enterprise Manager 13cR2 – How to apply Patch 23094292: WLS PATCH SET UPDATE 12.1.3.0.160719
This post was originally published on this siteMy fresh EM13cR2 installation showed me that there is a patch for the Weblogic environment available. This patch was released in July 2016: Patch Patch 23094292: WLS PATCH SET UPDATE 12.1.3.0.160719. This patchset has included 157 fixes and…