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
Tag: plsql
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
When upgrading, choose 19c not 18c
I had someone say to me at an event recently: “We’re are going to upgrade to 18c, because 19c is
Handling UTL_FILE_DIR and DIRECTORY objects
A couple of years back (wow…time flies!) I made a video and a post about the de-support of UTL_FILE_DIR in
