Miscellaneous


Topic

Description

10/10/2011

OOW 2011 presentation

Oracle Openworld 2011 features for developers

06/04/2011

SA presentations

SA March conference presentations

16/02/2011

AUSOUG presentations

AUSOUG presentations from 2010

22/11/2009

AUSOUG presentations

AUSOUG presentations from 2009

16/11/2008

AUSOUG presentations

AUSOUG presentations from 2008

16/11/2008

Not me...honest

You can't hold me responsible for this book

18/04/2007

Named Parameters

The dreaded named parameter in SQL

09/01/2007

Ugly files

A cute error message

20/06/2006

DBMS_SQL

Whoops...Oracle forgot something when they created VARCHAR2(4000)

13/01/2006

Hell

People on Oracle-L shared their hell stories...this is mine

08/09/2005

AUSOUG 2005

Download my presentations from AUSOUG 2005

08/09/2005

The LGWR dilemma (updated)

LGWR is meant to write every time you do a commit....but!

10/04/2005

UKOUG 2004

Download my presentations from UKOUG 2004

21/01/2005

Comparing text

Can two fields of different lengths be considered equal?

09/11/2004

DB Forum

The final Miracle database forum

29/04/2004

CASE in v8

The CASE statement in v8i has a quirk or two left

04/02/2004

NULL check

An interesting thread on string comparisons

23/09/2003

Day 1

Thoughts on OracleWorld Day 1

23/09/2003

Day 2

Thoughts on OracleWorld Day 2

23/09/2003

Day 3

Thoughts on OracleWorld Day 3

23/09/2003

Day 4

Thoughts on OracleWorld Day 4

20/08/2003

Unix vs Windows

A nifty little SQL Plus features for cross-platform scripts

01/01/2003

"Smart DBA"

A little gloating on my part

01/01/2003

UKOUG

Some pictures from Oracle User Group conference UK, Birmingham Dec 2002

01/01/2003

OracleWorld

Some pictures from OracleWorld 2002 in San Francisco, Nov 2002

20/08/2002

SAMPLE clause

The SAMPLE clause is more than just a "sample"

01/10/2001

Another Quote

Another quote that takes the breath away

09/04/2001

Shared pool quirk

An odd observation in the shared pool (Updated: 12/04/2001)

25/01/2001

SQL on object types

A weird anomaly when selecting from an object type

08/09/2000

Upgrading to 8i.2?

Two thing (1 trivial, 1 serious) thing to watch out for when upgrading to 8i.2 (8.1.6)

31/07/2000

Magic Dates

A new "feature" of 8 in magically working out your date format masks

19/07/2000

Humourous Quote

An interesting quote from a "DBA"

06/04/2000

Environment variables

Simple method of obtaining environment variables from the database

10/03/2000

Dates in Forms

Some registry tweaks to improve date input/output in Forms

11/02/2000

Change the prompt

How do I show the database name in the SQL Plus prompt

10/02/2000

Graphical 8i Install

How can I use the GUI 8i installer on a remote machine

09/02/2000

DBA Evolution

The huge mistake companies make when using their DBA's

06/02/2000

Business days

Retrieving only business days from a date range

(always more to come...)


All content on this page is provided on an "all care, no responsibility or liability" basis
The use of very basic html on this page is designed to increase the speed at which each page is downloaded.
It has nothing to do with my wealth of html knowledge :-)