Learning is not a spectator sport
Connor McDonald on SQL and the Oracle Database
Category: Uncategorized
The definition of proof
One of the pieces of advice that I often see on the ‘net is that undo space is somehow this incredibly precious thing, and as a consequence, one should always keep the amount of uncommitted changes in the database to a small size. Personally…
A refreshing look at PIVOT
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…
All the OpenWorld 2019 downloads!
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…
Then OpenWorld mega-list
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…
Extending in-lists
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…
Speaker info for Perth, Australia
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 OpenWorld!
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…
