Learning is not a spectator sport

Evolution

I’m a bit of a dinosaur when it comes to how long I’ve been using Oracle. But you should never

I recently posted a little video on the ‘exitcommit’ option in SQL Plus, adding a theatrical drama to present a

I’m lazy when I connect to the database, especially on my laptop. Anything that saves a few keystrokes I’m keen

Here’s a couple of simple examples to get you started with transposing rows to columns. The problem typically presents as:

Last week in Perth, we held a “Lets Talk DB” event. This was a free event organised by our local

Most people are now aware that in 12c, a VARCHAR2 has been extended from a maximum size of 4000 to

I’ll be presenting at a “Lets Talk Oracle” event in Perth, with fellow Ex-Oracle ACE Directors Richard Foote and Chris

In the previous post, I mentioned that for a programming environment fetching rows from the database, then the method of

In various programming environments, a common metaphor is to open a cursor on the database (a REF CURSOR in Oracle

If you create a trigger that does not compile, any part of your application that refers to the table with