It's that time of the year. It's time to say goodbye to summer. It's time to set the clock and get back to normal time. ... It's also time f...

TL;DR: You don't have to be a genius to solve problems. And there is no shame in not-knowing or not understanding all the geeky details. Ma...

TL;DR No, SYSDATE is not deterministic. However, it behaves very similarly to a deterministic function within an Oracle Database SQL statement. Background On a customer site, we used faketime on the O...

The last several years I've participated in the Joel Kallman Day tributes with articles about SQL and PL/SQL. While there are no requirements for article topics, this year I wanted to contribute something within the framework Joel was best known for... APEX. Many reports aggregate data over time periods and will usually return different dates and times as distinct rows. In some reports though, it is more useful to show a rolling window of time.

TL;DR: You don't have to be a genius to solve problems. And there is no shame in not-knowing or not understanding all the geeky details. Ma...

Triggered by traumatic DML errors ? Well, here's one flashback you won't mind having...

I recently inherited the support of an application that had been written on Oracle 11g. One of the maintenance tasks was to create a new set of partitions every so often so that records with a new value in the list partition key could be created without erroring.Fortunately, the application is now running on 19c, which means I can just get Oracle to sort it out for me.

This post explores how you can unit test PL/SQL procedures that do not write to the database (other than the log table) by capturing dbms_output statements for use in a utPLSQL expectation. But first, a news flash Steven Feuerstein recommends using Skippy ! Sort of. Well, not in so many words.In fact, it's unlikely that he's aware of the little known Kangaroo aptitude for PL/SQL logging.

The latest instalment in the existential battle for the future of Software Engineering...well...Fantasy Football bragging rights.

One of the things I like about External Tables is that you can use them to read a file on the Database Server OS without having to leave the comfort of the database itself.Provided you have permissions on a Directory Object pointing to the appropriate directory, it's a simple matter to create an external table that you can then…

The AI / Fantasy Football experiment you didn't know you needed ! The bolt has gone in, the lightning has struck, and GafferBot is lurching toward Game Week 1 as manager of Artificial Idiot. What could possibly go wrong ?

It seems that the 90s are back in fashion.Not only are Oasis currently making headlines, but England's Women have just won a penalty shootout which featured Lucy Bronze chanelling 1996-vintage Stuart Pearce.SSH also originates from the 90s, but unlike Britpop, has remained current ever since.It will work ( and is standard on) pretty much any Linux server.

After 20-odd years of making my job that little bit easier, SQLDeveloper Classic still isn't quite ready for the Recycle Bin of history.

A stumble through how to get your bash scripts to send mails to your os user account on Ubuntu.

This post is really a note-to-self on the differences between the RANK and ROW_NUMBER analytic functions in Oracle SQL and why you don't need to fiddle about with the order by clause of ROW_NUMBER to persuade it to generate unique values.Now, I had planned to start by waxing lyrical about the simplicity inherent in that classic of Italian design, the Coffee Moka then segue into a demonstration of how these functions differ using the Fibonacci Sequence.

Let's face it, ensuring that you have regular backups of your home computer to a remote location can seem like a bit of a chore…right up to the time when you've managed to lose your data and need a fast and reliable way to get it back.If you're using Ubuntu, this task is made much easier by Deja Dup Backups…

Alt: Masked heavy metal singer

What do you do if you have no money but you do have a home network, a USB Thumb Drive and some time on your hands ? No. Not that...

Need to generate a CSV from your Oracle Data Warehouse ? Do you think zebras belong in the wild and not in a data centre ? Read on...

The SQL_SCRIPT job offers the facility to run SQL*Plus from the comfort of your own database, provided you have a Credential for an OS user on the database server. Here's how to setup a suitable user from scratch, as well as some thoughts on why you might want to avoid using the oracle account for this purpose.