Column names you should NOT use
We all know from our data modelling days… (Sidenote: Remember those days? You know…when we used to think about good
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
A weekend audit Often if you see the words “weekend audit” in a non-technical sense, it means that awkward moment
At college/university, the learning path for a computing-related course often includes several coding languages, and occasionally some treatment of database
I was doing some code review today of a PL/SQL package, and came across a routine to generate a list
This one just for fun today. An AskTOM question came in about arbitrary length arithmetic because “NUMBER(38) was not enough”.
I had an AskTOM question come in with an issue trying to PL/SQL on an Active Data Guard (ADG) database