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
The unix command scp is very useful for transferring files between two hosts over a secure connection, but sometimes you need to kick off an scp command that will take several hours to complete and you want to disconnect and …Read More
Sometimes while developing scripts you want to keep backups of certain files, but are worried that over time the old versions will fill the filesystem and need housekeeping.
The following function will allow you to keep only <n> versions of …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