Whilst developing some administrative functions within PL/SQL I needed to know whether the database that the code was being run in was part of an Oracle DataGuard setup, which you would think would be a trivial exercise.
My first thought …Read More
When writing scripts to be run via SQL*Plus it’s often a good idea to check that the script is being executed as the desired user, and to abort with an error if this is not the case. This is especially …Read More
Sometimes it is necessary to determine if a value in a varchar column actually contains a number. The code below gives examples of how to do this.
All versions of Oracle
The code below created a stored procedure that can …Read More