Publications


	*www .Just SQL. com*

		*a site for the SQLPlus specialist**

The author has presented widely within the Oracle community as well as the general database world, in both the UK and at various European countries. These events include the UK annual OUG conference, the local Scottish OUG meetings, the European Oracle Users, Open World, Polish Oracle User Group, as well as various research institutes. The papers presented here represent eaxmples of some of these presentations.

They are held as MS Word documents within zip files.

“Generating SQL”	This is the key paper which underpins most of the work presented on this web site. It has been published by UK-OUG in their quarterly publication ‘Oracle Scene’, 2002. Abstract
“Replication - An Implementation in SQL”	A technical overview of a fully-functional asynchronous replication entirely within SQL. *Abstract*
*Table Backup and Recovery using SQLPlus**	Paper concentrates on Backup and Recovery; the associated presentation covers replication, as a process which takes considerable advantage of the Backup and Recovery foundations. *Abstract*
Exception Reports	A discussion of a variety of types of exception reports where declarative constraints cannot assist in maintaining database integrity. This is the full (conference) version of the paper; a cut-down version has been published by UK-OUG in 'Oracle Scene', issue 23, Autumn 2005. *Abstract*
Understanding Regular Expressions	The powerpoint is Here (zip file) The scripts for generating Expressions are here: build_regexp_like and build_regexp_instr


	Additional papers will be added.


	[Home] [Inspiration] [About this Site] [Scripts Intro] [Publications]


	e-Mail Connection