for Oracle Developers and DBAs

White Papers / Links / Resources

SQL 2003 SQL 2003 support in Oracle 10g
Password Hashing An Assessment of the Oracle Password Hashing Algorithm
Making Friends Making friends with the Oracle database
SQL Injection Data-mining with SQL Injection and Inference
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
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
Site maintained by Martin Chadderton
OCP - Internet Application Developer OCA - PL/SQL 9i Developer OCE - SQL Expert Follow mchadder on Twitter