plsql – Learning is not a spectator sport

The Importance Of Testing

In last weeks’ Office Hours session, I posted an “impossible” challenge to two of the most well credentialed Oracle community

A phrase I’ve often used when discussing database design is “insurance policy”, namely, when I talk about adding CHECK constraints,

Just an addenda to what I posted last week about downloading the Formula 1 motor racing data where I provided

A friend threw me a puzzle yesterday which I thought would be challenging, but turned out to be easy to

(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