Saturday, December 5, 2020

10 GOTO enesi.no

›
I haven't updated this blog for a long time. If you find anything useful here, you should probably upgrade your database. I'll leave...
Sunday, March 26, 2017

Too Easy for a Post: Install Oracle 12.2 with Vagrant

›
If you like the simplicity of Docker, but would like to continue with Virtualbox, then Vagrant is for you. After the conference in Dublin,  ...
Sunday, March 5, 2017

Adding Examples to a Docker Container with Oracle database 12.2

›
Oracle Database 12.2 became available for download last week. This weekend I've been playing with Docker and created a container with it...
Monday, February 20, 2017

Splitting a String into Elements

›
Every 4 months or so I need a simple way to split a string (VARCHAR2) into elements, where the elements are separated with some fixed value ...
Sunday, February 19, 2017

ORA-1722 and Regular Expressions

›
Yesterday I was importing some data I downloaded. When creating a new table I tried to convert two columns with latitude and longitude, stor...
Wednesday, November 30, 2016

Delete Cascade with Recursive PL/SQL

›
If you need to delete all rows in a table that has parent keys for other tables' foreign keys, and the foreign keys constraints have not...
Sunday, October 23, 2016

Displaying Spatial Data in SQL Developer

›
There are many ways to display spatial data, but when exploring a new data set in SQL Developer I think the built in Map View is practical. ...