|
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
|
|
ANSI Joins
|
ANSI JOIN Syntax
|
|
Analytic functions
|
Information about various OLAP analytic functions which can be used within SQL
|
|
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.
|
|
Using NULLs
|
How much do you understand about NULL?
|
|
Deadlocks
|
Getting ORA-00060? Then look here...
|
|
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)
|
|
Message Queueing
|
Various techniques for Message Queueing
|
|
Object Relational
|
In-depth technical information about the OR features of Oracle RDBMS
|
