Oracle Programming

OraSQL (slides) is an add-in that permits Excel to fetch records from an Oracle database (or any other datasource accessible via ADO or ODBC); it provides both interactive and programmable interfaces.

Sweeper is a set of tables and a PL/SQL program that automate test scripts to search for invalid data in a large database.

The catenate function performs an aggregate (like sum, count, average, min and max) combining string-valued fields from several records into a single record; it's useful when you are stuck with an unwanted one-to-many join.