Multi-threading can be accomplished at many levels- Separate stages that run parallel to each other, in Concurrent Manager request sets- Using DBMS_JOB.SUBMIT at the database level- Compiled Pro*C files (Oracle does this with PYUGEN for example)- Unix background processes- Scripting language such as Perl- Java- JSP- etcHowever, in the wise words of someone else I know, sometimes the simpliest answer achieves the desired goal. Shell Scripts, when you get down to it, are pretty simple. No real complex logic in most cases. more »

HANDY ONE-LINERS FOR SED (Unix stream editor) Apr. 26, 2004 compiled by Eric Pement - pemente[at]northpark[dot]edu version 5.4Latest version of this file is usually at: http://sed.sourceforge.net/sed1line.txtTYPICAL USE: Sed takes one or more editing commands and applies all of them, in sequence, to each line of input. After all the commands have been applied to the first input line, that line is output and a second input line is taken for processing, and the cycle repeats. The preceding examples assume that input comes from the standard input device (i.e, the console, normally this will be piped input). One or more filenames can be appended to the command line if the input does not come from stdin. Output is sent to stdout (the screen). more »

HANDY ONE-LINERS FOR AWK 22 July 2003 compiled by Eric Pement version 0.22Latest version of this file is usually at: http://www.student.northpark.edu/pemente/awk/awk1line.txtMost of my experience comes from version of GNU awk (gawk) compiled for Win32. Note in particular that DJGPP compilations permit the awk script to follow Unix quoting syntax '/like/ {"this"}'.However, the user must know that single quotes under DOS/Windows do not protect the redirection arrows ( ) nor do they protect pipes (|). Both are special symbols for the DOS/CMD command shell and their special meaning is ignored only if they are placed within "double quotes." more »

We ran into a situation where we needed to email encrypted zip files to a client generated from reports. Using the Oracle Applications as a platform for entering the parms, I created a simple approach to fulfilling this requirement. It could be expanded to support PGP, Mime attachments, etc. However, it works as is. To see the setup of job and shell script, click the Read More link below. more »