Available in the Downloads section of our website are a number of scripts & utilities that we've made available that you may find useful.
Scripts include :
Merge Points
This code takes a series of points (stored in an Oracle Spatial SDO Geometry) and merges them to create a line geometry. The code allows you to specify a point "order" so that the line is assembled correctly.
Spatial Union for Locator
This code implements a function roughly equivalent to the SDO_AGGR_UNION function in Oracle Spatial. It is intended for use on Oracle Standard Edition platforms where it is undesirable, for whatever reason, to upgrade to Spatial. (Note: this code does not work in Oracle XE due to the lack of Java support in that edition).
MID/MIF Export
Allows you to export Oracle Spatial tables as MIF/MID files directly from PL/SQL
Oracle GeoRaster Load Scripts
A useful batch file that simplifies the process of loading TIF/TFW files into Oracle GeoRaster
Simple Centroid
This (really) simple script can be used to create a centroid geometry for another geometry. It is intended as a basic substitute for the Oracle Spatial function SDO_GEOM.SDO_CENTROID, if you only have Oracle Locator.
All these scripts can be found in the Downloads section of the website. You will need to register first before you can download them.