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
Tag: plsql
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
Cloning a schema with a one line command
In the world of DevOps, continuous integration and repeatable test cases, the demand for being able to quickly build a
The definition of proof
One of the pieces of advice that I often see on the ‘net is that undo space is somehow this
