| White Papers | |||
 SQL 2003 |
SQL 2003 support in Oracle 10g |
SQL Injection |
Data-mining with SQL Injection and Inference |
| Passwords |
An Assessment of the Oracle Password Hashing Algorithm |
||
| Links / Resources / Articles | |||
 Metalink Notes
|
Quick links to Metalink notes I can't live without!
|
11g New Features
|
The Top New Features for DBAs and Developers |
| Technical Information | |||
|
PL/SQL Compiler Flags
|
An investigation into the new PL/SQL compiler options in 10g |
SQL/XML and XPath |
Great mechanisms for efficiently generating and processing XML from SQL |
|
Message Queueing
|
Various techniques for Message Queueing (MQ)
|
ANSI JOINs
|
9i ANSI JOIN Syntax
|
|
Object Relational |
In-depth technical information about the OR features of Oracle RDBMS. |
OLAP Functions |
Information about various OLAP functions which can be used within SQL. |
|
Colocation |
An explanation of the various types of colocation techniques (Partitioning, Clustering etc.) |
Triggers
|
Why (and why not) you may (or may not) want to use database triggers! |
|
FGAC
|
How to effectively use Fine-Grained Access Control (FGAC) |
SQL Injection |
Understanding and preventing database exploits. |
|
SQL tracing
|
Various techniques for obtaining the execution path / trace file. |
Instrumentation |
Mechanisms for effectively instrumenting your application code. |
|
Using NULLs |
How much do you understand about NULL? |
Deadlocks |
Getting ORA-00060? Then look here. |
|
Auditing |
Information on how to audit various operations such as connections etc. |
Using Views |
Why database views are the best thing since sliced bread! |
|
Cardinality
|
How to interpret and influence estimated cardinality |
Scalar Subqueries |
How to utilise this little known feature! |
|
Lists to Collections |
Converting from one to the other (and vice versa)! |
||
|
Site developed and maintained by
Martin Chadderton
|
|
|