(Simon Greener) A reader asked me for some help constructing and querying oriented points a few months back. The functions I created for him were one to create an oriented point from an normal point and a supplied whole circle bearing (0-360 degrees); the other was one that, given an oriented point,

(Jared Still) What started out as an investigation into how the optimizer deals with predicates that are outside the known range of value became something else when I tried to determine just what Oracle believes low and high values of the range to be.

(Simon Greener) In Developing Some Ideas For The Compression/Decompression Of Sdo_Geometry Objects, I Had Cause To Create Two PL/SQL Functions called Geocompress and Geodecompress.

(Bram van Pelt) Last month I helped a customer integrate a legacy application with Oracle Enterprise Single Single On (ESSO) version 11.1.2.3. I configured the legacy application within ESSO so the login manager would recognize the screens and log the user in. I got it all to work, but ran into a pr

(Owen Allen) I saw a question recently about the users and groups that are created on the EC and PC operating systems as part of an Ops Center install. Back in 11g, we had a section in the docs that showed these users and groups, but it’s missing in 12c.

(Hemant K Chitale) In the previous post, I demonstrated what a trace of UPDATE or DELETE would show (or not show). For example, although Index blocks need to be updated, we cannot identify how many Index blocks were updated.

(Dirk Nachbar) Within the new release of Oracle WebLogic Server 12.2.1 is a really cool new feature for Data Source System Properties.

(Martien van den Akker) Since september 2014, SOA & BPM Suites are available. As you may know, the biggest difference in developer experience is the introduction of the QuickStarts, that installs a JDeveloper including a preconfigured IntegratedWeblogic that has the SOA and BPM components have insta

(Simon Greener) At the business I am currently contracted to to provide database modeling, data quality analysis, PLSQL development and spatial expertise, an application was having problems querying a WFS server (MapGuide, using FDO to access an Oracle 11gR2 database) with a WFS filter using a very

(David Fitzjarrell) Edition-based Redefinition can be a real asset when modifying existing application code such as procedures, packages and functions but it can also throw a monkey wrench into the works when invalid objects rear their ugly heads, as ORA-00600 errors can be thrown in Oracle release