APEX_DATA_PARSER turbo boost!
One of the most common recommendations I’ll make to customers who post questions on AskTom is “Install APEX even if
Tag: plsql
Big bits – really long bit strings
A while back we had an AskTom question about arbitrary length addition and subtraction, and so I whipped a small
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
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
