Database Administrator Tools and SQL Scripts

DBA Scripts - Shell - SQL Scripts

ColdFusion SQL string in cfquery tag single quote problem and workaround.
Perl scripts to extract rows or columns from many Excel spreadsheets..
Security script to check Oracle default passwords.
Script to Convert Oracle, Informix schemas to other RDBMS.
Oracle rman script examples RMAN to Veritas backup and recovery.
How To: Export from Access Database No mouse clicks!
SQL script using Oracle date functions to create a time dimension.
Oracle script Index attribute order and cardinality.
Oracle script Find bad index design
shell - awk script for Informix or Oracle referential constraint graph.

Informix SPL converts datetime to Visual Basic integers.
Match DB session to Baan bshell
baan_who_oracle.ksh Oracle/Baan, match DB session to bshell.

exp-imp-db.ksh Export and import compressed files in Oracle.
ugly_DDL.ksh Extract SQL from Oracle
db_create.sql Oracle8.0.5 SQL to create instance
object_date.sql Oracle SQL to check DDL change time
oracle-shell-wrap Wrap sqlplus with ksh.

SQL Database example Hacks for relational algebra.

HOW TO Install Informix SE on Caldera Linux.

Unix Shell and Awk Scripts

A ksh - awk script search cgi Shell can do anything, even CGI.
Statistical Spam Filter Works
(with the spamfilter script, now with self updating whitelist)
Shell script to restart Baan license server
Shell script Find processes over time limit.
Shell script to find missing HTML references.

Database Administration and SQL Scripts
All stuff © Steven Hauser Steven.Hauser-1@tc.umn.edu