We had an AskTOM question come in recently where our customer was very excited about the PIVOT operator in SQL which lets you transpose rows to columns. This is a very common requirement in applications that want to take data that has been modelled in “pure” relational form, and present in a more “human-digestible” form. There are plenty of posts and examples out there about PIVOT, but if you haven’t seen one, here’s a trivial example just so that you are up to speed for the rest of this post.

Why dig around for hours in the catalog? Here are all of the downloads registered in the OpenWorld catalog!

You can pick and choose from the list below, or if you want a CURL script that will download the entire set, you can find that here. Enjoy!

BOF1167 Java on Azure BOF,Reza Rahman

BOF1321 Why You Should Be Coding with the NetBeans IDE,Mark Stephens

BOF1336 How to Improve the Quality of Your Application (I Wish I’d Known This Earlier!),Ioannis Kolaxis

You’ve been to OpenWorld…

You’ve seen the great content…

Networked with the community…

But now you want to keep the ball rolling and catch up with the speakers on twitter.

So here is the mega-twitter list…all the speakers from OpenWorld and CodeOne that provided their twitter handles at registration. Enjoy!

A well known “limitation” of Oracle is that you can only have 1000 elements within an IN-LIST style expression in your SQL predicates. I use the quotes because I’ve always found that if you are heading into the territory where you need more than 1000 items in an IN-LIST, then it is often indicative of something else being wrong. For example, if the code is backing a user interface, then where in the design phase did someone not go “Whoa…we are going to have 1000 select-able elements on the screen?”

In any event, you can find many tricks and techniques out there on the intertubes about how workaround this issue, such as:

I have just got back from the Groundbreakers Latin America tour, and the travelling was made so much easier with the information provided by the organizers. So with the APAC tour coming up, I felt duty bound to give some hopefully useful information about my home town in Perth.

Flying in/out

There are two airport terminals in Perth. In times gone by, these were known as the Domestic and International terminals because, as the names suggest, domestic flights within Australia landed at one, and flights from overseas landed at the other. Hence locals will still refer to the terminals as “domestic” and “international”. However, due to all sorts of politics and bickering between airlines, times have changed.

Just a couple of weeks away, and my oh my, I am going to be busy at OpenWorld this year!

Of course, first cab off the block will be the OpenWorld swim! It it September and marvellously warm in San Fran, so what better year to come along and meet new friends, and get free coffee and donuts! Just grab a towel from the hotel and head down to the marina!

Register at the link below, so we know how many donuts to buy!!!

Many moons ago I did a short video on the DML error logging feature in Oracle. The feature has been around for many years now, and is a great tool for capturing errors during a large load without losing all of the rows that successfully loaded. You can watch that video below if you’re new to DML error logging.

But here is a possible new use case for DML error logging, even if you are not doing large scale loads. Let me describe the problem first, and then show how DML error logging might be a solution.

I’ll create a table with a constraint on it’s column

I stumbled upon this post by optimizer guru Nigel Bayliss last week, so please have a read of that first before proceeding. But I wanted to show a simple demo of how management of cursors continues to improve with each version of the database.