Utilities

A handy template for creating scripts for Oracle with Perl and DBI.

Perl DBI Template for Oracle


This may be useful if you need to directly control printers from your Perl scripts. It is quite old, but it still worked on Perl 5 when I last checked.

Control Printers from Perl


Use Perl to get real time output from PL/SQL via debug pipe.

DBMS_PIPE, Daemons and Perl


If you need to dump a single table to a CSV file, along with the SQL-Loader control and parameter files needed to reload it, this SQL script will do it.

SQL Table Dump Utility


Oracle 9i Automatic PGA Memory Management

Oracle 9i+ Automatic PGA Management


.dirs.pkg .dirs.pkg

Shell script utilities for managing unix directory paths.

As seen in Sandra Henry-Stocker's article Favorite Tricks, Take Two


SQL in Korn Shell CoProcesses sqlshell-shell.tgz

Shell scripts designed to use shell coprocesses. This allows you to run SQL statements directly from the Unix shell command line. I'm not sure why you might want to do that, but it was kind of an interesting exercise.

Works with Korn shell, not sure about Bash.