PL/SQL Utilities

This is a list of some PL/SQL utilities and techniques that I have found useful. I hope you do too.

Writing Code for Mutiple Columns

How to use Excel to help generate code.

Re-assigning Foreign Keys

A little utility I wrote to help with data cleaning - it allows you to safely delete duplicates by re-pointing any foreign keys that reference the row you wish to delete to the row you wish to keep.

Linear Calendar

A package for displaying dates across the top, people or topics down the side and graphically showing activities in a Gantt-like layout.

OID Authorisation

A package which allows pl/sql and Application Express applications to use the Oracle Internet Directory to manage authorisation using OID Groups.

Lobs Over Database Links

An easy way to transfer CLOB, BLOB and other large data columns over a database link.

Sending Email from the Database

How to send plain text and html emails using the UTL_SMTP package.

Sending Appointments from the Database

How to send iCal format calendar appointments using the UTL_SMTP package.