ORA-00001: Unique constraint violated

There's a new version of Oracle Application Express (APEX) in town, and one of the new "features" is a new region type called...

Today it's exactly ten years since I published my blog post called Mythbusters: Stored Procedures Edition .  Using "stored procedur...

I've released a new version of Quick PL/SQL, the code generator for PL/SQL based on the same concept as QuickSQL in APEX, but for PL/SQL...

Maybe you've heard about " Quick SQL ", a utility (previously a separate application, now part of APEX 18.1 itself) that gener...

The APEX_UTIL package in Oracle Application Express is a mixed bag of "miscellaneous" stuff. From the documentation : " You...

Slack is a web-based chat room popular with many companies. Slack also has an API that can be used to post messages to a given "channe...

Like last year, Tim Hall of oracle-base.com fame suggested we should all do an "ODC Appreciation Day" in honor of the Oracle Deve...

I've been using Sublime Text as my main editor for PL/SQL development for many years, but I'm now in the process of switching to Vis...

Do you need to accept payments for goods and services via your (APEX) application and would you prefer to handle the payments in the databas...

This is a follow-up to an old post I did about how to backup Oracle database schemas to Amazon S3 using PL/SQL . In short, the packages...

Earlier this week, Santa's little helper (ie DHL) knocked on my door and delivered a package containing my trophies from the Oracle Dat...

Do you need to send SMS (Short Message Service) text messages from your Oracle database using PL/SQL? This is actually quite easy to do, the...

I'm honored to have been nominated for the Oracle Database Developer Choice Awards 2015 , in no less than three (!) categories: PL/SQ...

Somewhat inspired by Douglas Crockford's Javascript: The Good Parts presentation (and book ), I have created a presentation called PL/S...

I ran into a problem the other day when moving some code from one database to another (both XE 11g). The code in question needs to convert a...

Have you ever, like me, been silently finger-counting the number of characters in a table name, column name or procedure name that you are a...

The PL/SQL Utility Library, codenamed "Alexandria", now has a new home at GitHub . This will make it easier to collaborate on the ...

In my previous blog post , I took a look at the new APEX_JSON package that ships with Apex 5.0 and its capabilities for parsing JSON. In t...