Category Archives: Oracle

OTN APAC 2014 : The Journey to Perth

It was a pretty uneventful morning. I did my normal trick of checking everything was turned off, then checking again, just in case… I breezed through baggage drop-off and security in record time, barely breaking stride. We were a little late getting on the plane and stared taxiing out to the runway before everyone was […]

An Idiot (trying to get) Abroad

I’ve been wittering on about my latest trip and how manic everything is during the lead up to leaving. The panic reached new heights over the weekend when I remembered I hadn’t submitted my eVisitor application for Australia. I did it and figured I would get a decision in a few minutes like you do […]

UTL_HTTP, SSLv3, TLSv1 and POODLE

With the recent publicity about the POODLE bug, many web masters are turning off SSLv3 support. Depending on your Oracle database version/patch, that can present a bit of a problem for people using UTL_HTTP to access HTTPS resources, as described here. UTL_HTTP Package Fails With ORA-29273 ORA-28860 When Using TLSv1 (Doc ID 727118.1) : Basically, […]

MySQL : What management tools do you use?

A quick question out to the world. What management tools do you use for MySQL? We currently have: MySQL Workbench : It’s OK, but I don’t really like it. It feels like half a product compared to tools I’ve used for other database engines… phpMyAdmin : I’ve used this on and off for over a decade […]

OTN APAC Tour 2014 : It’s Nearly Here!

In a little less than a week I start the OTN APAC Tour. This is where I’m going to be… Perth, Australia : November 6-7 Shanghai, China : November 9 Tokyo, Japan : November 11-13 Beijing, China : November 14-15 Bangkok, Thailand : November 17 Auckland, New Zealand : November 19-21 Just looking at that list is scary. When I look […]

Oracle ACE Program: Follow Up

I just wanted to write something as a follow up to my recent and provocatively titled Oracle ACE = Oracle’s Bitch? post. Obviously, that subject has been preying on my mind a little… I said before, it is hard to be objective about yourself, so maybe some aspects of the “being an Oracle ACE changes you” […]

Pattern Matching (MATCH_RECOGNIZE) in Oracle Database 12c

I’ve spent the last couple of evenings playing with the new SQL pattern matching feature in Oracle 12c. Pattern Matching (MATCH_RECOGNIZE) in Oracle Database 12c Release 1 (12.1) I’m doing some sessions on analytic functions in some upcoming conferences and I thought I should look at this stuff. I’m not really going to include much, […]

Oracle ACE = Oracle’s Bitch?

I got a comment today on my recent Oracle fanboy post, which I thought was very interesting and worthy of a blog post in reply. The commenter started by criticising the Oracle license and support costs (we’ve all had that complaint) as well as the quality of support (yes, I’ve been there too), but that […]

Roll up! Roll up! Nothing new to see here! (Database Web Services)

Over the years I’ve written loads of stuff about consuming and publishing web services directly from the database. I’ve been doing quite a bit of this at work recently and I realised how difficult it is to find all the pieces, since they are spread across multiple articles, spanning multiple database versions. In an attempt to […]

Oracle fanboy and blind to the truth?

I had a little exchange with someone on Twitter last night, which was initiated by him complaining about the cost of Oracle and predicting their demise. Once that was over I spent a little time thinking about my “fanboy status”. If you know anything about me, you will know I’m an Oracle fanboy. I’ve spent […]