PL/SQL – GTech corner

Sorting and merging geometries in Oracle Spatial

Stephan Deckers November 9, 2017 5 Comments

Consider a requirement where an unsorted set of geometries needs to be merged into a single geometry. Take for instance the following set of geometries where: a…

G/Technology

Identifierviews

Stephan Deckers August 28, 2013 0 Comment

If you select a feature, GTech shows the selected feature in Feature Explorer. The right area of feature explorer shows attributes of the selected feature, the left…

G/Technology

A would like to have G/Technology development environment

Stephan Deckers October 18, 2012 3 Comments

Every time I do a G/Technology project I like to discuss how things need to be done. One aspect that always turns up is how limited you…

G/Technology

Transferring G/Technology databases for development purposes

Stephan Deckers September 13, 2012 0 Comment

If you are busy with a team developing all kinds of GTechnology enhancements, you will find yourself most of the time in Oracle, configuring metadata, creating PL/SQL…

Debugging

Debugging Oracle PL/SQL from Visual Studio

Stephan Deckers May 4, 2012 0 Comment

I use TOAD for my day-to-day Oracle development, but I find it’s debugging experience very poor compared to Visual Studio. Using ODP.Net version 11 you can use…