ORA-00001: Unique constraint violated

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...

Oracle Database, Express Edition (XE) is a free version of the Oracle Database, currently available as version 11g (11.2) for Windows and L...

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...

Not long ago I suddenly realized I had published my 100th blog post, so I figure it's time to look back and write down some thoughts abo...

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

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...

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...

I just noticed that prices for Oracle Database running on Windows Azure have now been published . The prices for the virtual machines ...

Today I'm taking a look at the core packages of the PL/SQL language, namely the STANDARD and DBMS_STANDARD packages in the SYS schema....

I'm a big believer in the so-called "Fat Database" paradigm for data-centric business applications. I think I first heard ...

There is really a lot of amazing stuff that you can do using just the Oracle database and PL/SQL these days. I've made this diagram to i...