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
Tag: plsql
Expanded TYPE definitions for PL/SQL 21c
There has always been that odd conflict between the language you use for SQL versus the language you use for
PL/SQL in 21c gets amazing new loop iterators
“It’s a dead language” people said. “There’s never anything new” people said. Well, let me serve those people a slice
Updating my APEX 20.2 installation
One of (or should I say “another of”!) the very cool features of Application Express (APEX) is that by being
How to do a GRANT on an entire schema
TL;DR: There is no schema grant command in Oracle, but this routine lets you get close. Why no schema level
Automatically generate audit capture for tables
A weekend audit Often if you see the words “weekend audit” in a non-technical sense, it means that awkward moment
Completely free training for Oracle novices
At college/university, the learning path for a computing-related course often includes several coding languages, and occasionally some treatment of database
Code re-use in PL/SQL might just need SQL
I was doing some code review today of a PL/SQL package, and came across a routine to generate a list
Arbitrary length addition and subtraction
This one just for fun today. An AskTOM question came in about arbitrary length arithmetic because “NUMBER(38) was not enough”.
Active Data Guard – limitations on ROWTYPE
I had an AskTOM question come in with an issue trying to PL/SQL on an Active Data Guard (ADG) database
