Mar 122013
 

I’m an oldskool Oracle user, so I learned and used joins in the oldfashioned way. Just name all the tables in the WHERE-clause, and specify the join conditions, and use (+) for outer joins. Times change, and the new syntax has been around for years. Never really used it, but today I did, and I found this image on the internet, I thought I’d share it, since I think it’s quite helpful.

sql-joins

It clearly shows how to use LEFT and RIGHT joins.

Feb 152013
 

I received some files with only coordinates, which had to be loaded into Oracle. It’s not super difficult, but I thought I’d share it anyway. The files contain some comment lines first, easily recognized the the hash (#) as the first character. The rest of the lines are x, y and z separated by spaces, like this:

#[MetadataBegin]
#[OrderNumber]2013001
#[Measured by]Piet
#[MeasureDate]30-1-2013
#[MetadataEnd]
 58392.50 439762.50 -0.01
 58397.50 439762.50 -0.03
 58402.50 439762.50 -0.03
 58407.50 439762.50 -0.03

The control file should be like this (change the filename etc):

OPTIONS (DIRECT=TRUE,MULTITHREADING=TRUE)
LOAD DATA
INTO TABLE DEPTHDATA
WHEN 1-1<>'#'
FIELDS TERMINATED BY ' '
(ID SEQUENCE(1,1),
 GEOMETRY COLUMN OBJECT
 (
  SDO_GTYPE CONSTANT "3001",
  SDO_POINT COLUMN OBJECT
   (X FLOAT EXTERNAL TERMINATED BY ' ' ,
    Y FLOAT EXTERNAL TERMINATED BY ' ' ,
    Z FLOAT EXTERNAL TERMINATED BY ' ' )
   )
)

Aug 062011
 

Too bad my comment on the original post was deleted. Perhaps they don’t want to know what I had to say, or they don’t like C#? From the top of my head I wrote something like:
The original post.

I created a very simple C# implementation, a console application with hardcoded username/password and select-statement. It roughly has the same speed as the Pro*C (C routine) version, about 1.7 million ALL_SOURCE records in about 57 seconds. C# is a little more appreciated amongst managers, since C# developers are a lot easier to hire than Pro*C developers. Why on earth you want to fiddle around with Java when something needs to be done fast, puzzles me. Even Java 6 (don’t know about 7 yet) does not come close to the performance of .NET, let alone natively compiling languages.

Jun 172011
 

Oracle released SQLDeveloper version 3 a while ago. One of the new things is the support for Spatial. If you right-click on a table you will see “spatial” as the last item in the context-menu.

But my my my. We all know GeoRaptor is *the* plugin for SQLDeveloper when it comes to spatial. Now Oracle in all its wisdom tried to create the same thing. Mind the word of choice: “TRIED”.

Dear Larry, go party on your boat, watch IronMan2 or something, but leave software development to people that actually get it. Thank you Simon.

Dec 112010
 

So you want to develop in .NET, let’s say with Visual Studio 2008. Let’s say you want to create a program that interacts with your or any other Oracle database. Sounds pretty simple. New project, add references to the Oracle.DataAccess.dll and you’re good to go.

WRONG!

Visual Studio is a stupid 32bits program. So it doesn’t recognize the 64-bits libraries you just installed in the GAC. And to make things worse, neither does it recognize the 32-bits libraries when you install a 32-bits client (with ODP.NET) or just 32-bits ODP.NET.

THAT SUCKS.

Yes, I googled around. Yes, I tried numerous socalled solutions. Yes, the build runs succesfully. No, the exception about the Oracle dll won’t go away.

Thank you, oh great Oracle god, with ye allmighty knowledge (which roughly translates into: YOU SUCK!)

BTW Did you ever install ODP.NET? Or any other Oracle software or patch? No wonder clients pay me tons of money to have their Oracle shit sorted out. What’s wrong with a Next-Next-Finish installation on Windows? And wait a minute, what’s wrong with a Next-Next-Finish on every other OS? OUI you say? I know I’m old, and I already work over 2 decades with Oracle, but at least I had the decency to LEARN something in 20+ years.

Sep 302010
 

Unexpected news from Oracle: SQL Developer Data Modeler is now a free product. The first editions where free with the sidenote that it was going to be a paid product. The previous release was present in Oracle Global Pricing list and was not cheap. Only the viewer was free. Now Oracle’s website has a note saying that the Datamodeler is a free product: Oracle SQL Developer Data Modeler: Pricing FAQ. Unexpected, but welcome news.

Aug 052010
 

Dear Oracle spatial experts,

When I don’t license Oracle spatial, but only want to use Locator (as described in Appendix B of the Spatial User Guide), is it allowed to load the SDO Java classes into the database ($/md/admin/sdoloadj.sql)? Or does loading the Java classes mean that one switches to using Oracle Spatial, and thus requiring a valid license?

Comments are greatly appreciated. Perhaps Simon is reading this?