SQL*Plus is commonly used to extract data from an ORACLE database, by simply spooling query results out to a file. Generally by CSV, SQL*Plus extracts can be used for reporting data or viewing meta-data. There are various limitations to extracting to basic CSV however, one particular one being CLOBs; a good way to partially resolve …
Starting and stopping java services remotely via ssh is a simple process, however in the situation where you need to manipulate or understand active processes remotely, things are more difficult.
The find command is very powerful, especially when combined with the -exec option, you can find and copy files to different locations, even renaming them at the same time. The difficulty comes however, when trying to alter the filename (retaining the original filename), for example to add a new prefix or suffix.
On first installing Cygwin, the username is inherited from Windows, and the $HOME directory is created from this username. This is particularly annoying if Windows was originally set up with a multi-word username such as “Firstname Lastname”. This quick guide will show how to change the username and $HOME directory to something more simple.