Data Management
Project Management
Archived stuff
Cryptic crossword.
A bit about me.
Read my blog
Recent additions
Home
I've worked as an Oracle developer, architect and DBA for several years; working with several versions of the database. Oracle Corporation continues introduce genuinely useful features with each new version of the product. The benefits and limitations of new features are best figured out through using them. This is also true for older, proven features - it is safest figure out how things work before using them. Most of the articles below came about through such exploratory exercises. I hope you find them useful.

Oracle database design and development
  1. Generating Excel files using PL/SQL.
    A how-to on how to generate Excel files from Oracle. (Aug 2007)


  2. Dates in Oracle - arithmetic, formats and functions.
    An introduction to the date datatype and date manipulation in Oracle. (Jul 2006)


  3. SQL for Modelling.
    An introduction to SQL for modelling (SQL MODEL clause). (Oct 2005)


  4. Oracle Analytic SQL: An introduction.
    A tutorial on Oracle's analytic extensions to SQL. (June 2005)


  5. Designing efficient ETL processes in Oracle
    Some tips for the design of efficient data conversion processes in Oracle. (May 2005)


  6. Oracle Fine Grained Access Control
    Implementing row-level security in Oracle. (Jan 2004)


  7. Oracle SQL: Aggregation extensions
    An introduction to "cube" and "rollup" extensions of the "group by" clause. (Nov 2003)


  8. Java stored functions in Oracle
    Write, compile and invoke a Java stored module in Oracle. (Jun 2001)


Oracle Database Administration
  1. Oracle Backup and Recovery, Part III - Disaster Recovery Using RMAN.
    The final article in my three part RMAN series. This article discusses disaster recovery using RMAN backups. (Mar 2005)


  2. Oracle Backup and Recovery, Part II - Database Recovery Using RMAN.
    The second article in my three part RMAN series. This article discusses some recovery scenarios in detail. (Jan 2005)


  3. Oracle Backup and Recovery, Part 1 - Database Backups Using RMAN.
    The first article of a three part series dealing with RMAN based backup and recovery. This article shows how to script RMAN backups on Windows servers. (Jan 2005)


  4. Oracle Generic Heterogeneous Services and Transparent Gateways.
    A quickstart guide on connecting to non-Oracle databases from within Oracle . (Updated May 2005)