plsql – Learning is not a spectator sport

Before you case-insensitive your whole database!

(Familiar with case-insenstive collation already? Skip ahead to the “Side Effects”) A history of failed applications Before Oracle 12, a

Oracle dinosaurs whoops I mean “experienced professionals” know that for decades we have used the DBMS_UTILITY package to obtain the

I gave a talk at Kscope21 yesterday about common mistakes that we make during the database development cycle. To kick

One of the most common recommendations I’ll make to customers who post questions on AskTom is “Install APEX even if

A while back we had an AskTom question about arbitrary length addition and subtraction, and so I whipped a small

We all know from our data modelling days… (Sidenote: Remember those days? You know…when we used to think about good

There has always been that odd conflict between the language you use for SQL versus the language you use for

“It’s a dead language” people said. “There’s never anything new” people said. Well, let me serve those people a slice

One of (or should I say “another of”!) the very cool features of Application Express (APEX) is that by being

TL;DR: There is no schema grant command in Oracle, but this routine lets you get close. Why no schema level