Evolution
I’m a bit of a dinosaur when it comes to how long I’ve been using Oracle. But you should never
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