 |
|
|
Papers
|
Why Images in the Database
|
This papers discusses the reasons why you would store images in the database. The rules have changed, its now a case of justifying why you should not store them in the database.
|
Download
PDF 80Kb
|
|
Being Locked in Oracle
|
This papers discusses why once you start using Oracle you are locked into it, and why this is a good thing. From a performance, maintenance, management, design and tuning perspective having to work with the one database has more benefits than trying to build an application that is portable. Attempting this is going to fail and cost the organisation more than they realise.
|
Download
PDF 96Kb
|
|
ProActive Database Management
|
This papers covers the theory behind setting up a database environment where the DBA never fights fires and is always in control.
|
Download
PDF 163Kb
|
|
PL/SQL Performance Review
|
This papers looks at some of the PL/SQL Performance myths in Oracle 10.2.0.1 Will soon be updated for Oracle 10.2.0.2 and Oracle 11G
|
Download
PDF 260Kb
|
|
|
Presentations
|
Enterprise Manager
|
This presentation takes a critical look at Oracle Enterprise Manager
|
Download
Zip 514Kb
|
|
Hierarchical Queries
|
This presentation takes a detailed and technical look at how to write Oracle Hierarchical Queries
|
Download
Zip 2.6Mb
|
|
Regular Expressions
|
This presentation provides an overview as to how to write regular expressions in PL/SQL and SQL
|
Download
Zip 390Kb
|
|
Regular Expressions
|
This presentation provides a critical look at RMAN in Oracle 10.1
It must be stated that as of 10gR2 the Author has taken a very positive view of RMAN when initially he was very negative towards it
|
Download
Zip 580Kb
|
|
Web Services
|
This presentation gives an overview from a technical point, as to how to use Web Services in Oracle
|
Download
Zip 460Kb
|
|
XML A
|
This presentation gives a high level view of XML covering the important topics
|
Download
Zip 446Kb
|
|
XML B
|
This presentation provides example XSDs and script to create object tables with the aim to show how it is possible to load XML straight into an Oracle object (nested table structure).
|
Download
Zip 560Kb
|
|
UTL_TCP
|
This presentation provides a very detailed technical view of the UTL_TCP package, TCP/IP and how to use the package.
|
Download
Zip 480Kb
|
|
|
|
|
 |
|
